Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
I am trying to retreive data from Salesforce object into Excel sheet and would like to use Salesforce Object
https://learn.microsoft.com/en-us/power-query/connectors/salesforce-objects#connect-to-salesforce-ob...
I do not see the Salesforce Object in the list on my excel. What type of license do I need so I can see this object? Or is there any other way to enable this?
Thanks
I have a similar issue. I don't understand why I am able to connect to Salesforce objects and reports in Power BI, but this same connection is not available when using Power Query in Excel.
Following are options in Power BI:
Here are the options in Excel:
Which object are you trying to access? SFDC objects usually have many millions of rows, far beyond what Excel can handle.
| User | Count |
|---|---|
| 50 | |
| 39 | |
| 29 | |
| 18 | |
| 17 |
| User | Count |
|---|---|
| 68 | |
| 57 | |
| 40 | |
| 22 | |
| 19 |