Forum Discussion

Toynk Accounting's avatar
Toynk Accounting
Copper Contributor
Aug 25, 2017

Unable to Connect to Web Source With Credentials in Power Query

I have tried to connect to 20+ websites that require sign-in credentials using Power Query without success.  I am able to login using Chrome so the credentials are correct.  The error I receive is be...
BI & Data Analytics
Need Help
Justin1245's avatar
Justin1245
Copper Contributor
Mar 29, 2020

AlbertZ I am also facing the same exact issue. I have the correct credentials, yet, when I enter them into the PowerQuery (web) section, excel tells me it is invalid. Anyone find solutions?

matagi's avatar
matagi
Copper Contributor
Mar 30, 2020

Justin1245 

Try also to open "Internet Explorer" then login to the site. Then once you are logged in, refresh query.
I have to do this always, in my case. If IE is closed, query fail to refresh (unable to connect). Hope this will help

  • Tim Scott's avatar
    Tim Scott
    Copper Contributor
    Mar 30, 2020
    From my discussions with Microsoft, PowerQuery does not handle authentication.
    To avoid having to open IE, you will need to use the legacy wizard.

Resources