Excel Power Query fails to connect to salesforce

[christophel]

since few days, in Excel, I cannot import data from Salesforce Report.

It fails to login to Salesforce

Office365 Enterprise, Excel 2007, win 10

I tried with Power BI desktop, it connects well to the reports.

[michelleferrier]

Looks like Microsoft are aware of this issue and are updating on this thread:

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_o365b/power-query-ex...

[v-eachen-msft]

Hi @christophel ,

It works properly in Power BI, you could post your topic in Microsoft Excel Community. The experts over there may have more solutions.

[Anonymous]

@v-eachen-msft wrote:

Hi @christophel ,

It works properly in Power BI, you could post your topic in Microsoft Excel Community. The experts over there may have more solutions.

---

 @v-eachen-msft   I have been unable to fix the SF connector in PowerBI for about a year now- Talked w/ MS and they didnt have immediate plans to fix the below error:

"Can't access this page

We don’t support this browser. Try opening this page in a supported browser."

Was this ever a problem for you?  Did you find a workaround? This was the reason I was using Excel to connect in the first place ironically...

[michelleferrier]

@Anonymous Salesforce allow us to extend support for IE11 - if you go to Session Settings in Salesforce and then check the box, Extend Support for IE11 - it should then allow you to login. However this support ends in Demeber 2020, and I haven't seen anything where MS have planned for this to be fixed, and December 2020 is getting close...

[Anonymous]

Thank you for your reply.

Under the session settings for the data profile I am under, I only see what I pasted below.  Should this be session settings at another level?

Session Times Out After Session Security Level Required at Login Separate community and Salesforce login authentication for internal users Relax login IP restrictions Skip device activation Allow OAuth for Internal Users

2 hours of inactivity

[michelleferrier]

@Anonymous are you a system admin for your Salesforce org?

[Anonymous]

@michelleferrier  No I am not an admin.

[michelleferrier]

@Anonymous You'll need to ask your admin to make that change for you then 🙂 

[christophel]

posted to Excel community

https://techcommunity.microsoft.com/t5/resources-and-community/excel-power-query-fails-to-connect-to...

[iw-prb]

Have the exact same issue. When I try to get data from SF Reports or Objects and enter credentials, I just get presented with a blank "login" screen every time I submit my credentials. Getting data in Power BI works.

[SFAdmin]

Same problem started in last two days and I can't connect to Salesforce objects from existing workbooks or new ones.

[michelleferrier]

We are also having this problem - raised a case to Salesforce and was advised that Salesforce Support is unable to assist with issues related to third-party applications. Not ideal at all, and has only been happening since Summer '20 was released.