Archive

Archive for February, 2015

Use Power Query to connect to Salesforce custom domain

February 14, 2015 2 comments

Power Query Salesforce connector is great but it does not support Salesforce custom domain at the moment.

Well, that is the limitation of using the PQ UI. You can actually make it work if you use M directly.

With the help of Curt Hagenlocher from Microsoft, I figured out how. What he said:

You should be able to use a custom domain in Power Query itself by manually editing the formula to include the login domain name. That is, instead of
=Salesforce.Data()
You’d have
=Salesforce.Data(“https://my.custom.salesforce.com“)

 

 

Advertisements
Categories: BI, Power Query Tags: ,