Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
If I connect to a SalesForce report as a Dataset using PowerBi online it will pull the data in the same format as is presented on SalesForce.com, for example, this report on SalesForce has a custom formula to calculate row count etc which results in a summarized dataset. This is what I am trying to pull this summarized data and it is pulling through in this format when I use the online connector.
However, when I use the desktop client of PowerBi and connect to the same SalesForce report it will pull all of the underlying data which is 252,000 rows and is cut off @ the 2000 row limit.
Is there any way to get this summarized data layout in the desktop version of PowerBi - particularly because I want to mix in other data sources for this particular report.
Unfortunately the 2000 row limit is from the Salesforce Report API. One option is to use the Salesforce Objects connector in the Power BI Desktop to connect directly to the objects and build out any type of view you'd like. The option to enable relationship detection may also make this easier. It does require some rework from your original report however it won't have the 2000 row limit.
There is a request to change this on the Salesforce community site if you'd like to include your vote!