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
Tim Scott's avatar
Tim Scott
Copper Contributor
Aug 31, 2017

Hi,

We've been suffering from this problem for months and trying to get MS attention - maybe in the wrong places :-(.

see: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/20166799-provide-more-diagnostics-for-the-data-from-web-p

 

My latest response there shows my frustration and it was only through examination of the user-agent heder that Excel supplied that I found a link to this tech community and I was going to post a new thread before I found this one.

 

To one extent, I am glad we're not the only ones suffering - it might get some attention now.

On the other hand, I'm not holding my breath until I can see that someone at Microsoft has read and understood the problem.

 

Any tips will be very much welcome.

 

Thanks,

Tim

Ehren von Lehe's avatar
Ehren von Lehe
Icon for Microsoft rankMicrosoft
Sep 05, 2017

Tim, would you mind sending more details of your issue (along with a Fiddler trace, if possible) to pq2fb@microsoft.com? Please mention my name when you do so.

 

Thanks,

Ehren

  • Tim Scott's avatar
    Tim Scott
    Copper Contributor
    Sep 06, 2017

    Thank you for following up. I have emailed some details FAO: Ehren.

    • Tim Scott's avatar
      Tim Scott
      Copper Contributor
      Oct 16, 2017

      Thanks for assisting diagnosis, Ehren. I've posted a new suggestion as a result of this:


      https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/31900633-re-enable-authentication-capability-for-the-powerq

Resources