Reply
Highlighted
Member
Posts: 62
Registered: ‎10-12-2016
Accepted Solution

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


Accepted Solutions
Moderator
Posts: 9,858
Registered: ‎03-10-2016

Re: salesforce connectivity - 2000 lines restriction

[ Edited ]

@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


All Replies
Moderator
Posts: 9,858
Registered: ‎03-10-2016

Re: salesforce connectivity - 2000 lines restriction

[ Edited ]

@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.
Frequent Visitor
Posts: 8
Registered: ‎01-17-2017

Re: salesforce connectivity - 2000 lines restriction

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