Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Salesforce Reporting row number Limitations

Hi    Their is a known issue where PowerBI can only pull the first 2000 rows from a Salesforce report. Is this issue being resolved? Is PowerBI working with SalesForce to remedy this?
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    The 2000 row limit is from  Salesforce Report API but not from Power BI. You can contact Salesforce support about this row limit as this is fully in their control.

    As a workaround for the above issue, you can use Salesforce Object connector in Power BI Desktop to pull all the rows from individual tables and recreate reports you’d like. The Object connector doesn’t have the 2000 row limit.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

The 2000 row limit is from  Salesforce Report API but not from Power BI. You can contact Salesforce support about this row limit as this is fully in their control.

As a workaround for the above issue, you can use Salesforce Object connector in Power BI Desktop to pull all the rows from individual tables and recreate reports you’d like. The Object connector doesn’t have the 2000 row limit.

Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous  I can't access SFDC tables directly due to company policy... Is there any other workaround where i can get connected to report and get complete data. I am expecting around 15K rows in my SFDC report.

  • Madi's avatar
    Madi
    Frequent Visitor
    6 years ago

    What about data security? Will google be able to see data?

  • BK's avatar
    BK
    Frequent Visitor
    3 years ago

    from the solution provided to this, seems google is able to address this through its salesforce data connector for google sheets. How come it is not a limitation then in Power Query Salesforce reports connector? salesforce report connector in power query must be fixed too.

  • metrica's avatar
    metrica
    Post Prodigy
    3 months ago

    Hi everyone,

     

    For anyone landing here from search in 2026: adding one more option to the workarounds already mentioned in the thread.

     

    A different category is Metrica Power BI Connector for Salesforce - it's an AppExchange app installed inside your Salesforce org rather than running through external middleware. Same outcome (pulls Salesforce Reports without the 2,000-row cap), but the data path stays within Salesforce-to-Power-BI directly, no external SaaS in between.

     

    Free 30-day trial if you'd like to test it. Setup guides at https://metricasoftware.com/, demo available on request.

     

    Cheers,

    Metrica Team.