Home > BI, Power Query > Use Power Query to connect to Salesforce custom domain

Use Power Query to connect to Salesforce custom domain

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: ,
  1. February 18, 2015 at 8:13 am

    Reblogged this on SutoCom Solutions.

  2. Patric Kaufmann
    March 5, 2015 at 11:23 pm

    I would also be interested a lot in using PowerQuery with custom domain. Unfortunately, even with yesterday’s new release of PowerQuery, this seems not to be possible. George, can you tell me where exactly I can edit this formula manually? Thanks a bunch!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: