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

Madi's avatar
Madi
Frequent Visitor
6 years ago

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