How to Connect Zoho CRM to Power BI

Moving your Zoho CRM data into Power BI opens up a world of powerful, interactive sales reporting that goes far beyond what’s possible in Zoho’s native dashboards. This article will show you the exact methods to connect Zoho CRM to Power BI, so you can build dynamic sales dashboards and uncover deeper insights about your pipeline.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Connect Zoho CRM to Power BI?

While Zoho CRM has solid built-in reporting, you’ll eventually hit a ceiling. When you need to blend sales data with information from other sources - like your marketing platform, finance software, or ad accounts - you need a more robust tool. That’s where Power BI comes in.

Benefits of a Power BI integration include:

• Advanced Analytics: Use Power BI's DAX (Data Analysis Expressions) to create sophisticated calculations and metrics that aren’t possible within Zoho, such as cohort analysis or complex lead scoring formulas.
• Data Mashups: Combine Zoho CRM data with other sources. You can finally build a comprehensive dashboard displaying your marketing ad spend right next to the sales revenue it generated.
• Interactive Visualizations: Build fully interactive dashboards that allow team members to drill down into reports, filter by salesperson or date range, and explore the data themselves without needing to ask for new reports.
• Customized Dashboards: Design sales dashboards pixel-perfect to your team's needs, focusing on the key performance indicators (KPIs) that matter most for driving your business forward.

What You’ll Need Before You Start

Before you get started, make sure you have the following ready to go. This will save you a lot of time and trouble later.

• Power BI Desktop: This is the free application from Microsoft used to build reports. You’ll need to have it installed on your computer.
• Zoho CRM Enterprise or Ultimate Edition: API access is a must for connecting to external tools like Power BI. These functions are typically available on Zoho’s higher-tier plans (Enterprise or higher). Check your specific plan details to confirm API access.
• Administrator Privileges: You'll need admin rights in both Zoho CRM and Power BI to handle authentication and manage the API settings necessary for the connection.

Method 1: Connect Directly Using Zoho's API and Power BI’s Web Connector

This is the most direct method, giving you full control over the data you pull. It requires working with the Zoho API, but don’t worry - we’ll walk through the process step-by-step. This approach essentially treats the Zoho API as a web-based data source.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Get Your Zoho API Credentials (OAuth 2.0)

First, you need to tell Zoho that Power BI is a safe application to share data with. You do this by creating an API client in the Zoho Developer Console.

1. Navigate to the Zoho API Console.
2. Click Get Started, which will prompt you to create a new client.
3. Select Server-based Applications as the client type.
4. Fill out the client details:
5. Click Create. Once it's created, navigate to the "Client Secret" tab. Here you will find your Client ID and Client Secret. Keep these safe and copy them somewhere secure, you’ll need them in a moment.

Step 2: Construct the API Request URL

Next, you need to know which data you want to retrieve. Zoho CRM’s data is organized into modules like "Leads," "Deals," or "Accounts." You’ll use a specific URL for each module.

The base URL typically looks like this:

https://www.zohoapis.com/crm/v2/{module_api_name}

For example, to get data from your "Deals" module, an initial URL might be:

https://www.zohoapis.com/crm/v2/Deals

To find the exact API name for standard or custom modules, go to Zoho CRM and navigate to Setup > Developer Space > APIs > API Names.

Note on Pagination: The Zoho API typically returns a maximum of 200 records per request. If you have more than 200 deals, you'll need to handle pagination by adding parameters like ?page=2 to the URL to get the next set of records. Managing this effectively in Power BI can get complex, often requiring Power Query functions to loop through all the pages.

Step 3: Connect Power BI to the Zoho API

Now, let’s switch over to Power BI Desktop and pull in the data.

1. Open Power BI and on the Home tab, click on Get Data and select Web from the common connectors list.
2. The Web connector dialog will pop up. Choose the Advanced option.
3. In the "URL parts" section, enter the API URL you constructed in the previous step (e.g., https://www.zohoapis.com/crm/v2/Deals).
4. Under "HTTP request header parameters," you'll need to add an Authorization header. This usually looks something like:
5. Click Connect. Power BI will ask you to configure authentication.
6. Choose Organizational Account and click Sign in. You’ll be prompted to sign in with your Zoho CRM credentials. Because you registered Power BI in the Zoho API Console, Zoho will recognize the request and grant access.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Transform the JSON Data in Power Query

Power BI won't immediately display your data in a clean table. The API sends data in a format called JSON, and you need to transform it into rows and columns using the Power Query Editor.

1. Once connected, the Power Query Editor will open, showing a record or list as the initial result. The main data is likely nested. You'll probably see a list named "data."
2. Click on "List" next to the "data" name to drill down into the records.
3. You’ll see a list of records now. In the top-left corner of this view, click the "To Table" button and then click OK on the next prompt. This turns your list of deals into a table with one column.
4. This column will contain multiple "records." Look for an expand icon (two arrows pointing in opposite directions) in the column header. Click it.
5. A list of all available fields from your Zoho module (like Deal Name, Stage, Amount, Closing Date) will appear. Select the fields you need and uncheck "Use original column name as prefix."
6. Click OK. Voilà! Your Zoho data is now in a clean, tabular format. You can click "Close & Apply" to load the data into your Power BI model.

You’ll have to repeat this process for each module (Leads, Accounts, etc.) you want to analyze in your report.

Method 2: Using a Third-Party Connector

If the API method seems too technical or time-consuming, a more straightforward option is using a dedicated third-party data connector. These tools are built specifically to bridge the gap between platforms like Zoho CRM and BI tools like Power BI.

Tools like Fivetran, Stitch, or Supermetrics act as middleware. They handle all the complicated API authentication, data fetching, and pagination for you.

How They Work

1. Sign Up: Start a trial or purchase a subscription to a connector service.
2. Authorize Your Accounts: You'll go through a simple, wizard-based process to connect both your Zoho CRM account and provide your Power BI details.
3. Select Your Data: In the connector’s interface, you’ll see a list of Zoho modules. Just check the boxes for the objects and fields you want to sync (e.g., Deals, Accounts, Contacts and their associated properties).
4. Connect from Power BI: The service provides you with a direct connector or server address to plug into Power BI's "Get Data" menu. The data often appears as if it's coming from a standard SQL database, making it very easy to work with.

Pros:

• Simplicity: No coding or API knowledge needed. The entire process is point-and-click.
• Reliability: These services professionally manage API changes and ensure your data is fresh and flowing correctly.
• Automated Refreshes: Data is automatically synced on a schedule you set (e.g., every hour), keeping your reports up-to-date.

Cons:

• Cost: These services come with a subscription fee, often based on data volume.
• Less Control: You're reliant on the data fields and objects the connector support, which may be less flexible than a direct API connection.

Best Practices for Your Zoho CRM Dashboard

Getting the data into Power BI is just the first step. To create a truly valuable report, follow these best practices:

1. Model Your Data Correctly

After pulling in multiple tables (e.g., Deals, Accounts, Activities), go to the "Model" view in Power BI. Create relationships between your tables. For example, link the Account ID from your Deals table to the Account ID in your Accounts table. This allows you to filter your deals by industry or region - data that lives on the Account record.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Focus on Key Sales KPIs

Don't just replicate your Zoho reports. Use Power BI’s power to build visualizations for metrics that truly drive decisions. Consider tracking:

• Sales Velocity: How quickly are deals moving through your pipeline?
• Win Rate by Source: Which lead source generates the highest quality deals?
• Pipeline Value vs. Quota: Are you on track to meet your targets for the quarter?
• Sales Cycle Length: How long does it take for a deal to close, on average?

3. Use the Right Visuals

Choose visuals that tell a clear story.

• A funnel chart is perfect for visualizing your sales pipeline stages.
• Use a combo chart to show sales numbers against quota.
• Use gauge charts to quickly show progress toward a key target, like monthly closed-won revenue.

Final Thoughts

Connecting Zoho CRM to Power BI lets you transform raw sales data into a strategic asset. Whether you prefer the control of the direct API method or the convenience of a third-party connector, either approach will unlock deeper reporting capabilities and help your sales team make smarter, data-driven decisions that grow your business.

While Power BI is a fantastic tool for advanced analysis, the setup process can be time-consuming. We built Graphed to solve exactly this problem for sales and marketing teams. Instead of wrestling with API keys, connector configurations, and Power Query, you simply connect your Zoho account in a few clicks. Then, you can use plain English to build real-time sales dashboards, asking questions like, "Create a dashboard showing our sales pipeline stages by rep for this quarter," and get an interactive dashboard built for you instantly.