Salesforce report data ends at 2000 records

[LisaHoffer]

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 anything beyond that number does not come over to PowerBI. If I export the Salesforce report all of the data is there (3,003 records) it's just not getting to PowerBI for some reason. I have NO plans of exporting this report to Excel daily to update PowerBI. Anyone else having this issue? Suggestions?

[v-haibl-msft]

@LisaHoffer

There is a 2000 row limitation for Salesforce. This is not a Power Query connector limitation but a general Salesforce Reports API restriction. For details, please refer to this link.

Best Regards,

Herbert