Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Joining Salesforce Data to Excel Sheet Data

Hi everyone!  I am looking to see if PowerBI supports joining two unrelated data tables into one project. I want to pull in data from a Salesforce sandbox, as well as an excel sheet. I then want to join this data into one table.


I was able to do this with Tableau, so I'm hoping PowerBI has a way!

Super User
Super User

It really depends on the complexity of your instance (how many objects would it take to recreate the report type, what is the size of the objects) and the number of rows you are expecting to get back from the report (there is an artificial 2000 row limit on all SFDC reports accessed via the API).


Personally  I prefer objects as they don't have a row limit and the connector now supports some mild query folding (ie it is producing custom SOQL for some of the transforms).

Super User
Super User

Sure. Are you using the Salesforce Objects or the Salesforce Reports connector?

I am currently using the Salesforce Reports connector because I have several objects I am trying to work with. But let me know if using objects is a better solution! I'm pretty new to PowerBI, so I'm sure there's more for me to learn. Thank you for your time!

Super User
Super User

Yes, that is possible. Be aware that Salesforce is case sensitive whereas Power BI (DAX) is not. Use CaseSafeID for the linkage if possible.

Hi! Can you please explain how to do this? I am not seeing an option to add another data source once Salesforce is linked. Thank you!

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors