Salesforce has the strongest built-in reporting of any mainstream CRM: custom report types, joined reports across objects, matrix and summary formats, reporting snapshots that store report results over time so you can see history, and dashboards with filters and scheduled refresh. For a sales team asking sales questions, it covers more than most people use. It runs out in three places: the component and filter limits on dashboards (there's a cap on components per dashboard and on filters, and you'll hit it), the people who need the numbers but don't have a Salesforce licence, and the join to the accounts system for revenue, margin and cash. Power BI connects to Salesforce natively through two connectors, Salesforce Objects and Salesforce Reports, and both need API access: included on Enterprise, Unlimited, Performance and Developer editions, an add-on on Professional, and the user's profile needs "API Enabled" ticked.
What does Salesforce's own reporting do well?
- Report builder. Tabular, summary, matrix and joined reports over any standard or custom object, with formulas, buckets, cross filters and conditional formatting. This is more flexible than HubSpot or Dynamics out of the box.
- Report types. Custom report types define which objects and fields a report can use, so admins can control what's reportable and how objects relate.
- Reporting snapshots. A scheduled copy of a report's results into a custom object, so "pipeline by stage on the first of each month" is possible inside Salesforce without any external tool. Most other CRMs can't do this.
- Dashboards. Components from reports, dynamic dashboards (run as the viewer), dashboard filters, subscriptions that email on a schedule.
- Opportunity history. The OpportunityHistory object records stage, amount, probability and close-date changes, which is what slippage and stage age need (see Sales Pipeline Report).
- Einstein / CRM Analytics. On the higher tiers or as an add-on, Salesforce's own analytics platform, which overlaps with what Power BI does for Salesforce-only data.
If your questions are Salesforce questions and your audience has Salesforce licences, build them here first.
Where does Salesforce reporting stop?
Dashboard limits. There's a maximum number of components per dashboard and of filters per dashboard, and reports have row limits when displayed. Large teams hit these and start splitting dashboards or paying for CRM Analytics.
The audience. A managing director, a finance team, a board, a partner firm. Salesforce licences are priced per user and the people above mostly won't log in. "Can we get the pipeline on a phone for the MD without a Salesforce seat?" is a common question and the answer inside Salesforce is no.
The join. Won opportunities against invoiced revenue, cost of sales and cash collected. Salesforce has the opportunity amount, which is what the rep typed. Revenue, margin and payment behaviour are in Xero, Sage, QuickBooks, Business Central or NetSuite, and a report that answers "which customers are actually worth having" needs both.
Cross-system KPIs on one page. Pipeline coverage next to utilisation next to overdue debt. Three systems, one page. Not a Salesforce dashboard.
What does the Power BI Salesforce connector need?
| Item | Requirement | Notes |
|---|---|---|
| Connector | Salesforce Objects (tables) or Salesforce Reports (report results) | Both native in Power BI Desktop and the Service; no third-party subscription |
| Edition | API access: Enterprise, Unlimited, Performance, Developer | Professional edition needs the API add-on; Essentials/Starter doesn't offer it |
| User | Profile with "API Enabled"; read access to the objects | A dedicated integration user is the usual practice |
| Authentication | Salesforce login via OAuth in Power BI | Security token or IP allow-listing may be needed depending on org settings |
| Refresh | Up to 8/day in a Pro workspace, 48/day on capacity | Cloud to cloud; no gateway |
| Power BI licence | Pro £10.80 per user per month (Microsoft UK, September 2026), paid yearly, excl VAT, for every viewer | Or PPU £18.50, or the workspace on capacity |
Source: Microsoft Learn, "Power Query Salesforce Objects connector", and Salesforce edition documentation, read 21 September 2026.
Which connector: Salesforce Objects for building a proper model (Account, Opportunity, OpportunityHistory, User, plus your custom objects, joined in Power BI). Salesforce Reports for pulling the results of a report someone already built, which is quicker but leaves the logic in Salesforce. For a model that'll be joined to anything else, use Objects.
The Professional edition point is the one that stops projects: if you're on Professional, the connector won't work until the API add-on is on your contract, and that's a Salesforce conversation, not a Power BI one. Check before scoping.
When does a Power BI model earn its place?
Same three situations as every other CRM:
The join to the accounts. Won opportunities from Salesforce, invoices and receipts from the accounts system, joined on a customer key both hold (account number, company registration number, or an external ID field on the Salesforce Account). This answers the sixth question in CRM Reporting. It's the one the MD asks.
The audience outside Salesforce. One page, on a phone, row-level security so each manager sees their team, no Salesforce seat needed. Power BI Pro at £10.80 is the per-viewer cost.
Definitions your finance director agrees with. Stage probabilities set from measured win rate over the last four quarters rather than the defaults; a weighted pipeline the board trusts; slippage and stage age from OpportunityHistory on the same page as the forecast.
What does it cost, and where do you start?
Use Salesforce's reports and dashboards first, including reporting snapshots for history. Then, if the audience or the join is the gap, a single-source Power BI report on Salesforce is what the First Report is for: one system, one report answering one written question, the headline figure reconciled back to Salesforce to the penny, published to your workspace, £1,950 fixed, ten working days. Salesforce is one of the named systems at the First Report. Salesforce plus your accounts is two sources and a Reporting Sprint.
Common questions
Does Power BI have a Salesforce connector?
Yes, two native ones: Salesforce Objects (reads tables) and Salesforce Reports (reads report results). Both are built into Power BI Desktop and the Service with no third-party subscription.
Why won't the Power BI Salesforce connector work on Professional edition?
Because it uses the Salesforce API, and Professional edition doesn't include API access by default. It's available as a paid add-on on Professional; Enterprise, Unlimited, Performance and Developer editions include it. The user's profile also needs "API Enabled".
Can Salesforce show pipeline history without Power BI?
Yes. Reporting snapshots store a report's results on a schedule into a custom object, and OpportunityHistory records stage, amount and close-date changes. Both are built in, which is more than most CRMs offer.
What are the Salesforce dashboard limits?
Dashboards have a maximum number of components and filters, and displayed reports have row limits; the exact figures are in Salesforce's documentation for your edition and change occasionally, so check there rather than a blog. Large teams typically hit the component limit first.
Can Power BI join Salesforce to Xero, Sage or Business Central?
Yes, if both systems hold a shared customer key. Store the accounts system's customer ID (or the company registration number) on the Salesforce Account as an external ID field, and the model joins won opportunities to invoices, cost and cash on it.
Should I use Salesforce Objects or Salesforce Reports in Power BI?
Objects, for anything you'll model or join: it gives you the tables and you build the relationships in Power BI. Reports is quicker for reproducing a report someone already built in Salesforce, but the logic stays in Salesforce.
Is Power BI or CRM Analytics better for Salesforce data?
For Salesforce-only questions with a Salesforce-licensed audience, CRM Analytics is the native option and worth evaluating. For an audience outside Salesforce, or for joining Salesforce to your accounts and other systems, Power BI is the tool, and its per-viewer cost is £10.80 a month on Microsoft's UK page as of September 2026.