Can't connect to Salesforce.com

[BILearner]

Hello All,

I can't connect to Salesforce.com(Lightening) via Power BI Desktop, I get the following error. 

However, I am able to connect via Excel's PowerQuery (PQ). I can't exactly figureout what is wrong however,  I got to know that Salesforce lightening dosn't support IE anymore which is used by PBI desktop for authentication, but then how it is working in Excel's PQ and not in PBI?

Can someone please help me with potential solution/Workaround? 

Thanks!

[ReportGuru]

Hi @BILearner were you able to find a solution? I've used the Salesforce connector but I had some issues too. As a workaround, maybe you can try to connect your SF data with a 3rd party connector. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

[Anonymous]

Hi All,

I changed the entry in the Registry Editor as described by @BILearner  but I am still getting the same error message:

Does anyone have another idea / work around on how to get access to SalesForce via PowerBI?

Thanks!

[Anonymous]

I got temproary salesforce admin rights and with those I was able to use the PowerBI internet explorer for authentifiaction.

[v-shex-msft]

Hi @BILearner,

I think you are working with web connector and web site that contains redirection or scripts, right?  AFAIK, power bi will block these redirects and javascript functions for security reasons and it will only get current page HTML elements.

You can try to get data from source API or get data from an excel file that connects to an external data source.

Regards,

Xiaoxin Sheng

[BILearner]

There's an out of the box connector for Salesforce objects and Salesforce Reports in PowerQuery for both Power BI Desktop and Excel. 

I am able to connect via Excel to Salesforce objects but it doesn't work in Power BI desktop. I do not understand why I am not able to connect in PBI when I can connect via excel?

Best,

Abhi

[v-shex-msft]

HI @BILearner,

Power query not fully equal to excel query editor, they have a few difference feature and functions.  As I said, they use different security management policies so some of the functions and features only work on excel side.

You can contact to excel team to know more about these differences and backend reasons.

Regards,

Xiaoxin Sheng

[nickpegnato]

To Community Support,

Do you know how we can change browser preferences on Power BI so that the 'Salesforce Report' connector, with a custom URL, can access the report I need? I am also running into the same issue as BILearner experianced in this forum.

I've already tried changing my default brower option on my PC (Chrome, Edge, Fire Fox) but to no avail.

[BILearner · Accepted solution]

The underlying cause of the problem is MS PBI uses IE11 for authentication and SFDC lightening has stopped supporting IE11.

MS Support provided me with following solution and it worked for me. 

To resolve this issue do the following.

1. Make sure you are using PBI Desktop downloaded from the MS Download Center and NOT the MS Store App
2. In Registry Editor location\  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION from decimal 11000 to 7000

[Hobbes2099]

I'm looking at the registry editor

but I don't know which registry item to change from 11000 to 7000

I see 4 posibilites

I really not want to play russian rulette with my registry.

[BILearner]

@Hobbes2099  Are you sure you have PBI version downloaded from the website here and not from Microsoft Store? 

If you have done above step your screen should look like below. 

Then change the value for PBIDesktop.exe