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

[LP008]

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

[CoderZen08]

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. 

[Anonymous]

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

[LP008]

@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: