cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aasheesh1
Advocate II
Advocate II

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
Microsoft

@aasheesh1,

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

5 REPLIES 5
v-yuezhe-msft
Microsoft
Microsoft

@aasheesh1,

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

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

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

@KWcpoint 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.

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors