How to Connect Salesforce Report to Power BI

Moving your Salesforce data into Power BI opens up a powerful new world of analysis, allowing you to blend your CRM insights with information from other business tools. If you're trying to build a comprehensive view of your business performance, this connection is essential. This guide will walk you through, step-by-step, how to connect your Salesforce reports directly to Power BI.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Connect Salesforce Reports to Power BI?

While Salesforce offers robust reporting on its own, Power BI takes it to another level. Think of Salesforce as the source of your core sales and customer data, and Power BI as the central hub where you can combine that data with marketing spend, web analytics, support tickets, and financial data for a complete picture.

Here are a few key benefits:

• Advanced Visualizations: Power BI provides a wider and more flexible range of charts, graphs, and interactive elements than standard Salesforce dashboards. You can customize visuals to tell a more compelling story with your data.
• Combine Data Sources: Want to see how your Google Ads campaigns are influencing your Salesforce sales pipeline? You can't do that easily within Salesforce alone. With Power BI, you can pull in data from countless sources and analyze their relationships in a single dashboard.
• Automated Data Refreshes: Once you set up the connection, you can schedule your Power BI reports to refresh automatically. This means your data is always up-to-date without anyone needing to manually export CSVs and update spreadsheets.
• Sharing with Anyone: You can share Power BI reports and dashboards with stakeholders across your company, even if they don't have a Salesforce license. This makes performance data more accessible to everyone from finance to senior leadership.

Before You Get Started: What You'll Need

To ensure a smooth connection process, make sure you have the following in place:

• The Right Salesforce Edition: The Power BI connector requires API access, which is available in Salesforce Enterprise, Unlimited, Performance, and Developer editions. Unfortunately, it won't work with the Professional edition unless API access has been added to your account.
• Salesforce Permissions: The Salesforce user account you use to connect must have the "API Enabled" permission in its profile. It also needs access to the specific reports you want to import.
• A Power BI Account: You'll need a Power BI Pro or Premium account to publish and share your reports, as well as to schedule data refreshes. You can build the initial report using the free Power BI Desktop.
• Power BI Desktop: This is the free application where you'll build your report. Make sure you have the latest version installed on your computer.

Method 1: Connect Using the Native Power BI "Salesforce Reports" Connector

This is the most direct and user-friendly way to get your Salesforce report data into Power BI. It uses a pre-built connector that's specifically designed for this purpose. The connector essentially translates your Salesforce report into a data table that Power BI can immediately use.

Step 1: Open Power BI Desktop and Select "Get Data"

Launch the Power BI Desktop application. In the "Home" tab of the ribbon, click on the Get Data button. A dropdown menu will appear. You can click More... at the bottom to open the full list of data sources.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Find the "Salesforce Reports" Connector

In the "Get Data" window, you'll see a search bar. Type "Salesforce" into the search bar to filter the list of connectors. You will see two options: "Salesforce Objects" and "Salesforce Reports." Select Salesforce Reports and click Connect.

Step 3: Enter Your Salesforce URL and Sign In

Power BI will now ask for the Salesforce URL you want to connect to. This is an important step. You have two main options:

• Production: If you're connecting to your live Salesforce environment, use the default URL (https://login.salesforce.com).
• Custom/Sandbox: If your company uses a custom domain (e.g., yourcompany.my.salesforce.com) or you are connecting to a developer sandbox, enter that specific URL here.

After selecting the URL, click OK. You'll then be redirected to a Salesforce sign-in window. Enter the username and password for the Salesforce account you want to use for the connection (the one with API access).

Step 4: Select Your Report from the Navigator

Once you've successfully signed in, Power BI will display a "Navigator" window. This window lists all the Salesforce reports that your user account has access to. The reports are organized into the same folders you use in Salesforce (e.g., Private Reports, Public Reports, and any custom folders you've created).

Find the report you want to import and click the checkbox next to its name. A preview of the report's data will appear on the right side of the window, allowing you to confirm it's the right one.

Step 5: Load or Transform the Data

At the bottom of the Navigator window, you have two options:

• Load: Click this if your report data is already clean and well-structured. This will load the data directly into your Power BI data model, and you can start building visuals.
• Transform Data: This is the recommended choice for most people. Clicking this opens the Power Query Editor, a powerful tool for cleaning and shaping your data before it's loaded. Inside the Power Query Editor, you can remove unnecessary columns, change data types (e.g., from text to a number), filter out rows, and more.

For example, you may want to remove the "Report Details" footer rows that Salesforce often includes in report exports. You can easily do this in Power Query by filtering out any rows where a key column is null.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 2: Connect Using "Salesforce Objects" for More Flexibility

While the "Salesforce Reports" connector is great for its simplicity, the "Salesforce Objects" connector offers much more power and flexibility, though it requires more work.

Instead of pulling a pre-structured report, this method connects you directly to the raw data tables (or "objects") in Salesforce, like Account, Opportunity, Contact, or Lead. This is useful when:

• Your report in Salesforce is too large or complex and times out.
• You want to pull in multiple related tables and create the relationships yourself in Power BI's data model.
• You want to create filters and logic that aren't possible within a standard Salesforce report.

The process is similar: go to Get Data, search for "Salesforce," but this time select Salesforce Objects. After signing in, the Navigator will show you a list of all standard and custom objects you have access to, rather than reports. You can select one or more objects, then use the Power Query Editor to replicate your report's logic by filtering, merging, and creating a data model.

Setting Up an Automated Refresh in the Power BI Service

Building the report is just the first half of the process. The real power comes from having the data refresh automatically. To do this, you first need to publish your report to the Power BI Service (the cloud-based version of Power BI).

1. In Power BI Desktop, click the Publish button on the "Home" tab. Select a workspace to publish it to.
2. Once published, open a web browser and go to app.powerbi.com. Navigate to the workspace where you saved the report.
3. Find the dataset for your report (it will have the same name), click the three dots (...), and select Settings.
4. In the settings menu, expand the Data source credentials section. Since you used your Salesforce login, Power BI can't reuse it for scheduled refreshes. Click Edit credentials.
5. A sign-in window will appear. Select OAuth2 as the Authentication method and sign in to your Salesforce account one last time. This securely stores your credentials for future automatic refreshes.
6. Now, expand the Scheduled refresh section. Toggle it on and choose your desired refresh frequency (e.g., daily) and time of day.

That's it! Your report will now automatically pull the latest data from your Salesforce report on the schedule you set.

Troubleshooting Common Issues

Sometimes you might run into bumps along the road. Here are a few common problems and how to solve them:

Why can't I see my report in the Power BI navigator?

This is usually due to one of two reasons. First, ensure the Salesforce account you're using to connect has explicit permission to view that report. Second, Salesforce reports must contain at least one row of data to appear in the connector. If a report is currently empty, it won't show up in the list.

Graphed

Still Building Reports Manually?

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

Watch the Demo

My scheduled refresh is failing. Why?

The most common cause is that the Salesforce password for the account used to create the credentials has changed or expired. To fix it, go back into the dataset settings in the Power BI Service and re-enter the credentials. Another potential issue is a change in Salesforce permissions, if the user loses access to the report or its underlying fields, the refresh will fail.

I'm getting a Salesforce API call limit error.

Salesforce limits the number of times external applications (like Power BI) can request data within a 24-hour period. If you have many reports refreshing frequently, you might hit this limit. To mitigate this, consider scheduling refreshes less often (e.g., once daily instead of hourly) or use the "Salesforce Objects" connector to pull in raw data and apply a filter in Power Query, which can be more efficient than running a heavy report.

Final Thoughts

Connecting Salesforce reports to Power BI is a powerful step toward building a holistic, data-driven culture. By creating a single, automated dashboard that combines CRM data with other key business metrics, you empower your team with comprehensive insights and free them from the tedious work of manual reporting.

While tools like Power BI are incredibly powerful, there's often still a significant learning curve and manual setup involved in connecting data and creating the right visualizations. At Graphed, we aim to eliminate that friction completely. We make it easy to connect your sources - like Salesforce, Google Analytics, and Shopify - and then use simple, natural language to build your ideal dashboard in seconds. You can ask for what you need ("show me deals closed this month by sales rep") and get live, real-time reports without navigating complex editors or writing any code.