Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
LP008
New Member

Power query error in power bi desktop : DataSource.Error : exceeded 100000 distinct ids

Hello Community,

 

Hope somenone can provide a solution or a workaround this...

I have a report connected to Salesforce Object. Until now everything was working fine, but recently I got this error : DataSource.Error : exceeded 100000 distinct ids when trying to load ProcessInstance Object into power query in power bi desktop.

 

From what I found so far it is a power BI limitation and not a salesforce one. I already have "view all data" permission set in salesforce.

 

Can anyone provide a solution and/or a way to load heavy objects in power query ?

 

this is the information I found on the help page of salesforce:  https://help.salesforce.com/s/articleView?id=000386735&type=1

 

Let me know if you would need more information on this.

 

thanks a lot !

 

LP

 

3 REPLIES 3
CoderZen08
Helper V
Helper V

Hi @LP008 were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector, which pulls data directly from the SF objects API. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

 

SALESFORCE-1.png

 

After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

 

SALESFORCE-2.png

 

 There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

 

SELECT_DESTINATION_NEW.png

Anonymous
Not applicable

Hi @LP008 ,

Please refer to the solution:
PBI: DataSource.Error: exceeded 100000 distinct who/what's - Salesforce Developer Community

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

@Anonymous  thanks I saw this topic, but do not have the capacity to filter out records or even to query on the data before loading it when connecting on SFDC objects. See below: 

 

 

image.png

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.