Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

salesforce connectivity - 2000 lines restriction

Hi,

 

Is there any solution to ensure ALL the rows in salesforce appear in power BI? Currently the restriction is 2000 rows.

 

I understand from earlier responses and searches that this is a Salesforce API restriction and not Power BI, but if im not wrong, this issue does not exists in Tableau, so why with Power BI?

 

Also, is connecting to salesforce objects a work around?

 

Thanks

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

Syndicated - Outbound

@Anonymous,

Based on Miguel’s response in this idea, the 2000 row limit is from  Salesforce Report API but not from Power BI. You can share this feedback with Salesforce 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,

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

7 REPLIES 7
QueryWhiz
Post Patron
Post Patron

Hi, connecting to SF objects like it's been mentioned would be a workaround. You can try to test your connection with a 3rd party connector. The difference between the native PBI objects connector and an external tool is that this one wil let you pre-filter your data in the tool UI before moving it to Power BI. 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...

v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Syndicated - Outbound

@Anonymous,

Based on Miguel’s response in this idea, the 2000 row limit is from  Salesforce Report API but not from Power BI. You can share this feedback with Salesforce 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,

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.

Syndicated - Outbound

Hi, I have a question

 

is the salesforce obejct connetor the online service from salesforce?

If I try to access/load this datas it tooks hours.

Thanks in advance

Manuela

avatar user
Anonymous
Not applicable

Syndicated - Outbound

Is there a way to limit the rows (fields) from the object when connecting directly to a Salesforce Object?

Syndicated - Outbound

@Anonymous Any chance you have a solution for this? We have pulled in a few objects, but there's due to large amounts of data PowerBI just keeps churning to return the results.  If we can limit the number of records being returned, we can vet out visualizations first.

Syndicated - Outbound

Hey!

 

Yeah, 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! =D

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)