Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce

[fbcideas_migusr]

In Power Query in Excel and in the Designer, the current implementation of "From Salesforce Report" is useless due to the Salesforce 2000 row limitation. Please push them to raise that. And please figure out how internally inside Power Query you can retrieve the first 2000 rows, then the next 2000 rows, etc. to get all the rows. Also please allow us to push filters to Salesforce so that the 2000 rows that are returned are from the date range we want. Allowing us to pass filters would let us iterate over a date table and run the report once for each day and then append the results, thus working around the 2000 row limit.

[sergio_onorato]

so it is a Microsoft limitation..

[lobrien2]

Is there any update on this? When will it get resolved?

[vignesh_rajakum]

Any Update ?

[dennis_depoorte]

So... it's a Microsoft problem (to lazy to change from one to another API --> SF BULK API). They blame Salesforce, so nothing happens. Simple laze solution from my side: I will not longer investigate to use of powerBI for my company!

[andrewcohen61]

Yes I was considering power BI as our salesforce reporting solution , but it appears that I will have to take the data outside of salesforce to get a full dataset connected. That requires another level of security, storage, and setup. Microsoft needs to fix the data connector API issue. Until they do I am going to recommend that we Skip power BI.

[dave_williams]

This limit is ONLY because Power BI chooses to use the standard API rather than develop a power BI connector to the asynchronous Salesforce BULK API. https://developer.salesforce.com/docs/atlas.en-us.api_analytics.meta/api_analytics/sforce_analytics_rest_api_limits_limitations.htm Other BI tools use the bulk API to get all (Millions) of rows.

[kevin_nelson]

Has Power BI updated their API for Salesforce to the Salesforce BULK API?

[jnnana]

Any update on this? Thanks

[fbcideas_migusr]

administrators - are you sure there is no solution to this limitation and address this?

how come google's salesforce data connector for google sheets doesn't have this limitation?

Check the below information sources:

Microsoft Idea (powerbi.com)

https://glazeforce.wordpress.com/2016/03/29/workaround-to-2000-record-limits-in-report-analytics-api-salesforce/