Forum Discussion
Power BI missing some data from SF report
aj1973 So I found the issue, I didn't realize it at the time but I got to messing with it again this morning. Salesforce native reporting allows a limit of 2,000 rows only unless you export the data. So the report was picking and choosing which data to show me on the screen but was reporting different data to Power BI. Still don't understand that one but I changed some edits in my SF report to limit the rows of data and everything is showing perfectly in Power BI. Thanks again for reaching out to offer assistance. Cheers!
aj1973 So I found the issue, I didn't realize it at the time but I got to messing with it again this morning. Salesforce native reporting allows a limit of 2,000 rows only unless you export the data. So the report was picking and choosing which data to show me on the screen but was reporting different data to Power BI. Still don't understand that one but I changed some edits in my SF report to limit the rows of data and everything is showing perfectly in Power BI. Thanks again for reaching out to offer assistance. Cheers!
Hi TMO_KY,
Glad you found it! For anyone landing here with the same symptom, quick clarification on what's happening: the 2,000-row limit you ran into isn't a Salesforce report limit per se - Salesforce UI can display tens of thousands of rows and the Export to CSV button handles even more. The cap is specifically on the Salesforce Reports API, which is what the native Power BI connector uses. So when your report exceeds 2K rows, the API silently returns just the first 2,000 (sort order picks "which" rows), while the SF UI shows everything.
The workaround you applied (trimming the report to fit) works, but it means your Power BI analysis is permanently scoped down. If you need the full dataset eventually, Power BI Connector for Salesforce on AppExchange pulls Salesforce reports without the 2K API cap - so your full report (Joe Snuffy and all) comes into Power BI as-is, no row trimming needed.
Free 30-day trial if you'd like to test it on your time-off report. Details at https://metricasoftware.com/, demo available on request.
Cheers,
Metrica Team.