Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
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:
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:
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.
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:
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
8 | |
8 | |
7 |
User | Count |
---|---|
17 | |
13 | |
7 | |
6 | |
6 |