Blog

How to Connect Salesforce to Power BI

To get started with how to connect Salesforce to Power BI, follow the steps below.

Step 1 : Click on “Get Data” in Power BI Desktop and Go to Online Services

How to Connect Salesforce to Power BI - Step 1 Get Data

You can now select Salesforce Reports or Objects from the list.

Step 2 : Select Salesforce Object and Click on Connect

How to Connect Salesforce to Power BI - Select Salesforce Object

Step 3: It will show the URL Selection,You can Connect production or Custom,Select Production and
Click OK.

How to Connect Salesforce to Power BI - URL Selection for Salesforce

Step 4: It will ask for access to the Salesforce, Click on the Sign in.

How to Connect Salesforce to Power BI - Salesforce Login Screen

Enter credentials and click login

How to Connect Salesforce to Power BI - Object List in Power BI

Step 5: After login you can see list of objects from Salesforce and select required Object to load.

How to Connect Salesforce to Power BI - Project Object Loaded

Sample PowerBI Report:

Step 1:

Loaded Project Object in to the PowerBI:

Step 2:

Drag and drop the Clustered Column chart on the Visual page:

How to Connect Salesforce to Power BI - Add Clustered Column Chart

Step 3: Drop ID from Project object to the Values field on Visualizations tools.

How to Connect Salesforce to Power BI - Drop ID in Values Field

Step 4: Add Date Field into the Axis and Format the chart in visual format.

How to Connect Salesforce to Power BI - Format Chart with Date Axis

Step 5: Drop slicer from visuals and add Year field on that

How to Connect Salesforce to Power BI - Add Year Slicer

Now You can see the Number of projects started by Month in filtered Year.

How to Connect Salesforce to Power BI - Final Filtered Report View


We are Inno Valley Works, We are a passionate team of developers, best thinkers and consultants who can solve anything and everything.
With our highly engaging team, you can easily bring the vision to all your business ventures come true.
We have team, put your problem, get your solution

🎥 Check Out Our YouTube Channel

Explore helpful tutorials, product updates, and feature walkthroughs from the team at Innovalley Works.

👉 Visit Our Channel