Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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,
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...
@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,
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?
@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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
50 | |
19 | |
12 | |
11 |