Forum Discussion

WESTi's avatar
WESTi
Icon for Helper I rankHelper I
10 years ago

PowerBi Online SalesForce report connector pulls dataset in different format to PowerBi Desktop

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 f...
Need Help
TPalmer's avatar
TPalmer
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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!