Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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?

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
ReportMaster
Post Patron
Post Patron

Hi. As a workaround, maybe you can try to test your connection with a 3rd party connector, which pulls the SF data from the SF objects API, therefore you'll avoide this rows limitation on SF end. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

 

SALESFORCE-1.png

 

After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

 

SALESFORCE-2.png

 

There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

 

SELECT_DESTINATION_NEW.png

TaxiDad
New Member

You can upvote the request to increase that 2000-row limitation. The more votes, the more likely it will be changed. Here is that link. https://ideas.salesforce.com/s/idea/a0B8W00000GdYvXUAV/power-bi-communicate-with-microsoft-developme...
EugeneLebedev
Helper IV
Helper IV

You can work around this limitation using third-party tools. Here is the approach that I would recommend: https://vidi-corp.com/connect-salesforce-reports-to-power-bi/
 
This approach essentially extracts data from Salesforce reports in chunks of 2000 rows each and then appends them together. As a result you get all the columns you need in a single table.
 
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

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

Anonymous
Not applicable

@v-yuezhe-msft  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.

I have the same problem. Is there any workaround?

Hello!

 

I have found a way to bypass this problem.

 

You can check it out here: https://community.powerbi.com/t5/Power-Query/How-to-Bypass-Salesforce-2000-Rows-Limitation/m-p/90010...

 

Hope it is useful!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.