Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 Sale...
Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    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,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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,

manuelaschuster's avatar
manuelaschuster
New Member
6 years ago

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