PowerBi Desktop and Salesforce help

[salman_ali]

Hello team,

i am trying to connect to our company Salesforce using PowerBi Desktop.  I click on Get Data, which gives me two options.  One is Salesforce Reports and the other is Salesforce Objects.  

When I cleck on Salesforce Reports, the tables are in a good format, but I can only access limited amount of records (2000 at one time), where as if I click Salesforce Objects, data is all available however formatting is atrocious.  

How do I pull in data in complete form yet also have it in acceptable formatting 

[v-eachen-msft]

Hi @salman_ali ,

You could refer to this idea:

https://ideas.powerbi.com/ideas/idea/?ideaid=5d5c21de-52d7-404b-9b6d-b0ed0acb0a19

it is not a Power Query connector limitation but a general Salesforce Reports API restriction. Please make sure to share this feedback with Salesforce as this is fully in their control. In fact, once/if they remove this API limit, there wouldn’t be any product change required on the Power Query connector to pull the entire dataset, as there’s not any explicit limit defined on our side.

And you could vote for this idea to use Bulk API.

[amitchandak]

@salman_ali , refer to these if they can help

https://www.blendo.co/guides/salesforce-power-bi/

https://blog.pragmaticworks.com/tales-from-sales-hurdles-with-salesforce-connectors-in-power-bi