Salesforce data in Power BI

1. 1

   Use Salesforce Objects for the model

   Get data → Salesforce Objects, sign in, and pick Opportunity, Account, User and OpportunityHistory (for stage changes). Select only the columns you report on: Salesforce objects carry hundreds of fields and wide tables slow refresh.

2. 2

   Use Salesforce Reports for one-off views

   Salesforce Reports imports a report as it is defined in Salesforce. It is convenient but returns the report's own columns and is subject to Salesforce's report API limits, so build the model from Objects and keep Reports for quick checks.

3. 3

   Model a star schema

   Keep Opportunity as the fact table with a Date table related on CloseDate, and Account, User (owner) and Stage as dimensions. Add a stage sort-order column so funnels follow the sales process rather than the alphabet.

4. 4

   Schedule refresh in the Service

   Salesforce is a cloud source, so a gateway isn't needed for scheduled refresh. Set credentials on the semantic model in the Service and refresh before the forecast call.

Open Pipeline = CALCULATE ( SUM ( Opportunity[Amount] ), Opportunity[IsClosed] = FALSE () )

Win Rate = DIVIDE ( CALCULATE ( COUNTROWS ( Opportunity ), Opportunity[IsWon] = TRUE () ), CALCULATE ( COUNTROWS ( Opportunity ), Opportunity[IsClosed] = TRUE () ) )

Attainment % = DIVIDE ( [Closed Won], SUM ( Quota[Amount] ) )

Avg Cycle Days = AVERAGEX ( FILTER ( Opportunity, Opportunity[IsWon] ), DATEDIFF ( Opportunity[CreatedDate], Opportunity[CloseDate], DAY ) )

Coverage = DIVIDE ( [Open Pipeline This Qtr], [Quota Remaining] )

• Currency: multi-currency orgs store Amount in the opportunity currency; use the converted amount field or a rate table, never sum mixed currencies.
• History: Opportunity holds the current stage only. Stage-by-stage conversion needs OpportunityHistory or field history tracking.
• Ownership changes: report on the owner at close for attainment and on the current owner for pipeline, and say which in the title.

• Executive template

  Executive KPI Scorecard

  Free Power BI executive dashboard template: five headline KPIs, revenue vs target trend, unit breakdown and a scorecard table on one 16:9 page.

• Sales template

  Regional Sales Performance

  Power BI regional sales dashboard template: a large sales map, four KPIs, revenue by region bars and a top-accounts table on one page.

• Sales template

  Sales Pipeline

  Power BI sales pipeline dashboard template with pipeline value, win rate and cycle-time KPIs, a stage funnel, pipeline creation trend and closing deals.

• Sales template

  Sales Rep Quota Attainment

  Dark Power BI sales quota attainment template: a rep leaderboard, bookings vs quota by month, attainment distribution, win rate and deal size per rep.

Power BI visuals for Sales · More by department: Sales templates · Executive templates

• Visual

  Funnel Chart

  Sales pipeline: leads → MQLs → SQLs → opportunities → closed won; Marketing funnel: impressions → clicks → landing page views → sign-ups

• Visual

  Bullet Chart

  Executive KPI scorecards (5-10 KPIs in a grid); Sales attainment across reps or regions

• Visual

  Waterfall Chart

  Revenue walk: prior year → price → volume → mix → FX → current year; Budget reconciliation: budget → categorical variances → actual

• Visual

  Heatmap

  Hour-of-day × day-of-week traffic or activity patterns; Correlation matrix between dozens of numeric metrics

• No connector of its own in Microsoft's list

  HubSpot in Power BI

  HubSpot data in Power BI

• Connector in Microsoft's list

  Dynamics 365 in Power BI

  Dynamics 365 data in Power BI via the Dataverse, Business Central and Customer Insights connectors

• Connector in Microsoft's list

  Excel in Power BI

  Excel data in Power BI

Salesforce is a trademark of its owner. Product names are used only to describe compatibility; VizForge is not affiliated with, endorsed by or sponsored by the owner or by Microsoft.