Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Schedule Refresh - Salesforce Reports

Hi   Due to the Power BI and Salesforce limitation of a maximum of 2,000 rows per query, I have had to split a report into 8 seperate reports.   When I publish to my workspace and go to schedule ...
General Comment
Need Help
metrica's avatar
metrica
Post Prodigy
1 month ago

Hello there,

 

I would not treat this as a fixed limit on the number of Salesforce reports. It looks more like the refresh becomes fragile when the original report is split into many separate Salesforce Reports queries.

 

The 2,000-row issue comes from the Salesforce Reports connector. If you keep splitting reports into smaller reports, scheduled refresh can become harder to maintain and may run into token, timeout, or API-related issues.

 

The cleaner native option is to use Salesforce Objects instead of Salesforce Reports, then rebuild the reporting logic in Power BI. The Objects connector does not have the Salesforce Reports 2,000-row limit.

 

Another option is Power BI Connector for Salesforce by Metrica Software: https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

 

It lets you prepare Salesforce data sources, select objects and fields, apply filters, preview the output, and use SOQL mode when needed. This can help avoid maintaining many split Salesforce reports just to work around the 2,000-row limit.

 

Docs and support:
https://metricasoftware.com/docs/salesforce/
https://metricasoftware.com/docs/salesforce/contact-support/

 

Cheers,
Metrica Team