Forum Discussion
LisaHoffer
Advocate II
Advocate IISalesforce report data ends at 2000 records
I have a report that runs in Salesforce and feeds my PowerBI desktop report. It is set-up to automatically update daily. We recently passed 2,000 line items (rows) in the report, and it looks like an...
metrica
Post Prodigy
Post ProdigyHi LisaHoffer
As @v-haibl-msft mentioned, the 2,000-row cap is a Salesforce Reports API limitation, not a Power BI one — so the only way around it is to bypass that API entirely.
If you'd rather not rebuild everything against Salesforce Objects (which can get tedious with custom fields and joined data), there's a purpose-built option on Salesforce AppExchange: Power BI Connector for Salesforce:
🔗 AppExchange listing: https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577
Why it fits this exact scenario:
- No 2,000-row limit — pulls full Salesforce reports as-is, columns and all
- Keeps your existing Salesforce report structure (no need to rebuild from raw objects)
- Supports custom fields, custom objects, and joined reports
- 30-day free trial, no credit card needed
- Setup docs: https://metricasoftware.com/docs/salesforce/
- Responsive support if you get stuck: https://metricasoftware.com/docs/salesforce/contact-support/
Happy to set up a quick demo if it'd help - we can walk through how it handles reports with 3K+ rows and how the Power BI side connects. Just reach out via the support link.
Cheers,
Metrica team