How to Connect Salesforce to Power BI: Step-by-Step Guide with AI-Assisted Setup

How to connect Salesforce to Power BI is a question that sounds simple until you actually try it. Power BI ships with built-in Power BI Salesforce connectors, but they come with row limits, authentication problems, and no governance for team use. This guide walks through the complete process using Power BI Connector for Salesforce, a Salesforce-native AppExchange application, including an AI-assisted setup option through Salesforce Agentforce for teams looking to streamline data source configuration.

Why Native Power BI Salesforce Connectors Are Not the Right Starting Point

Power BI’s built-in Salesforce connectors are the obvious starting point. They are free and require no additional installation. 

The Salesforce Reports connector works until you hit 2,000 rows — a hard limit with no workaround. 

The Salesforce Objects connector removes the row limit but loads entire Salesforce objects into Power BI memory before filtering, which creates slow refresh times and API quota problems at scale.

For Salesforce Power BI integration setup that holds up in production — reliable, scalable, and team-ready — a dedicated connector is the more practical choice.

Meet Power BI Connector for Salesforce by Metrica

Power BI Connector for Salesforce installs inside your Salesforce org as a managed package. Configuration happens inside Salesforce: you define a data source specifying which objects, fields, and filter conditions to export. Power BI then connects to a secure OData endpoint and pulls exactly that scoped dataset (no full object loading, no filtering after the fact).

Each user authenticates with their own access token, which inherits their exact Salesforce permissions. Data sources can be shared across teams so everyone works from the same configuration.

Step 1: Install Power BI Connector for Salesforce

Open Power BI Connector on Salesforce AppExchange, click Get It Now, and install into your production org. The installation follows the standard AppExchange flow.

After installation, three components need to be configured in Salesforce:

1. Salesforce Site — hosts the OData endpoint Power BI connects to. If your org already has an active Salesforce Site, you can use it and skip creating a new one.
2. Connected App — handles OAuth authentication between Power BI and Salesforce.
3. Custom Setting — stores the connector’s configuration details.

Full configuration steps are documented in the official Installation Guide. After saving the Custom Setting, wait approximately 10 minutes for the Connected App to activate before authorizing the connector.

Step 2: Create a Salesforce Data Source for Power BI

Once installed and authorized, the connector is immediately ready to use. Open Power BI Connector from the Salesforce App Launcher, go to Data Sources, and click Create data source.

1. Enter a descriptive name for the data source
2. Select the Salesforce objects you need (Account, Opportunity, Case, or any custom object)
3. Expand each object and select only the fields your report will use
4. Apply filters to limit the dataset — date ranges have the biggest impact on performance
5. Use Basic mode for standard filtering or switch to SOQL mode for complex query logic
6. Click Preview ERD to verify relationships between objects before saving
7. Save the data source

Keep each data source focused on one reporting use case. A sales pipeline source and a support source maintained separately are faster and easier to manage than a single configuration covering everything.

AI-Assisted Data Source Creation with Agentforce

Teams using Salesforce Agentforce can take advantage of an AI-assisted approach. Rather than manually selecting objects and fields, describe your reporting goal to the Agentforce agent and it will either recommend the right Salesforce objects and fields, or create the data source for you end-to-end — including filter conditions and the Power Query formula ready to paste into Power BI Desktop.

This is particularly useful for teams setting up reports on unfamiliar Salesforce objects or building data sources for multiple reporting use cases quickly. Agentforce integration setup is documented at metricasoftware.com/docs/salesforce/agentforce-integration/.

Step 3: Generate an Access Token

In the Power BI Connector app, go to Access Tokens and click Create Token. Enter a label, set an expiry date, and click Create.

Copy the token immediately after creation. It cannot be viewed again after leaving the page. Store it securely — a password manager is the appropriate location, not a shared document or spreadsheet.

Set expiry dates on all tokens. When team members leave or a connection is retired, revoke the token from the Access Tokens page. Revocation takes effect immediately.

Step 4: Import Salesforce Data into Power BI Desktop

Copy the Power Query Script

In the Data Sources list, click the Power Query copy icon next to your data source. This copies a ready-to-use script to your clipboard.

Set Up the Token Parameter

1. Open Power BI Desktop and create a Blank Report
2. Go to Get Data → Blank Query
3. Open Manage Parameters → New Parameter
4. Create a parameter named metricaToken with your access token as the current value
5. Click OK

Storing the token as a parameter keeps it separate from the query text, making it easy to update when the token expires without editing every query.

Connect and Load Data

1. Right-click Query1 in the Queries panel and select Advanced Editor
2. Clear the existing content, paste the copied script, and click Done
3. If prompted for credentials, select Anonymous and click Connect — authentication is handled by the token inside the query

For each Salesforce object in your data source, right-click the Table entry next to the object name and select Add as New Query. Rename each query to match the Salesforce object name exactly. Repeat for all objects.

Click Close and Apply. Your Salesforce data is now live in Power BI and you can start building reports and dashboards straight away.

Step 5: Set Up Scheduled Refresh in Power BI Service

To keep your Salesforce data current without manual intervention, publish the report to Power BI Service and configure a refresh schedule.

Power BI Pro supports up to 8 scheduled refreshes per day. Power BI Premium supports up to 48. Choose a frequency that matches your actual business cadence — refreshing a dataset hourly when decisions are made daily puts unnecessary load on Salesforce’s API quota.

For large and growing datasets, configure incremental refresh before publishing. Incremental refresh loads only new or changed records on each cycle rather than reloading the full dataset. See the Incremental Refresh Setup Guide for full configuration steps.

Tips for a Reliable Salesforce Power BI Connection

Apply date filters in every data source. Filtering by created date or modified date in the data source configuration is the single most effective way to reduce export time and API consumption.

Share data sources across the team. Once a data source is configured and working, share it with teammates via the Share option in the three-dot menu. Recipients can use it for exports but cannot modify the configuration. This prevents duplicate configurations that drift apart over time.

Monitor token expiry. Expired tokens cause Power BI refresh failures. Set calendar reminders to renew tokens before they expire, or use the Access Token History view to track active tokens across the team.

Use the ERD before you build. The Entity Relationship Diagram in the connector shows how selected objects relate before you save a data source. Checking this takes a few seconds and prevents incorrectly structured Power BI models that produce inaccurate aggregations.

Conclusion

Knowing how to connect Salesforce to Power BI correctly is the difference between a reporting setup that works reliably at scale and one that creates maintenance problems every time data volumes grow or team composition changes.

Power BI Connector for Salesforce handles the connection through a Salesforce-native architecture, with server-side filtering, shared data sources, and token-based authentication that inherits existing Salesforce permissions. The Agentforce integration adds an AI-assisted option for teams that want to accelerate data source creation without deep technical expertise.

Get started at the Salesforce AppExchange or explore the full documentation at metricasoftware.com/docs/salesforce/.