Forum Discussion

jpatel_st's avatar
jpatel_st
New Member
2 years ago

How to enable Salesforce Object from Excel using Power Query

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-objects-from-power-query-desktop

 

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

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Which object are you trying to access?  SFDC objects usually have many millions of rows, far beyond what Excel can handle.

  • ldetumpo's avatar
    ldetumpo
    New Member
    2 years ago

    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: