Excel Power Query authentication error

(0) Share

Report

Posted on by AlexandreRM1

Hello,

I'm facing a very annoying issue when I try to login into my organizational sharepoint site with Excel PQ. Here is what I get when click on the "Connexion" button:

PQ login error.png

The problem likely comes from the firewall/antivirus/... from my company, but they don't want to change anything.

I saw there was an option in powerBI (with which I'm facing the same issue) to use the default browser, instead of the webview popup, to login into authenticated data sources. Unfortunately this option is not available in Excel.

Do you know any workaround to have web authentication working in Excel?

Kind regards,

Alexandre