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 below. I have clicked Edit Credentials and re-entered the creds, only to get the same error. I have cleared the permissions in Power Query and re-done numerous times without success. Also, I'm certain I have used the feature successfully around a year ago. Is there a setting in Power Query that enables connecting with credentials? Any other ideas?

Hi Deleted. Is it possible that your old PC is using the MSI version of PBIDesktop, and your new PC is using the Microsoft Store version? Are they running the same numeric version of PBIDesktop as well? Ehren

Deleted Great. The MSI version overrides a few Internet Explorer settings (which is what Web.Page uses behind the scenes), and the store version isn't (yet) able to override those settings. These settings must be what allows this particular page to work for you. Ehren

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

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

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

Unable to Connect to Web Source With Credentials in Power Query

27 Replies

Lokesh_REDDY
Copper Contributor
May 17, 2020
Toynk Accounting

Hi,

Share your URL to connect using Power Query.
- Toynk Accounting
  Copper Contributor
  May 17, 2020
  Lokesh_REDDY
  
  https://squareup.com/dashboard/sales/transactions
AlbertZ
Copper Contributor
Feb 05, 2020
I´m dealing with exakt the same problem. Any news to that? Searched the whole web, but no success.
- 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
    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
Deleted
Sep 28, 2019
Toynk AccountingDo you have updates on this issue? I am currently facing same problem. But I find it a bit weird as it was working fine in my old laptop. I just posted my case few hours back.

https://techcommunity.microsoft.com/t5/Excel/Excel-Query-From-Web-Old-laptop-OK-new-PC-not-OK/m-p/880612
- Tim Scott
  Copper Contributor
  Sep 28, 2019
  Deleted I thought I'd posted my workaround, but maybe not here.
  Briefly: it won't work with this new style, you have to re-enable the legacy data wizard and use that.
  This does still work - I used it last week.
  
  https://support.office.com/en-gb/article/data-import-and-analysis-options-3ea52160-08bc-45ac-acd9-bc4a11bcc2a2
  - Deleted
    Sep 29, 2019
    Tim Scott Tried to enable legacy data wizard but still didn't work. I also tried to use Power BI and gave me save result. New PC unable to fetch other tables. Is there a special data connector microsoft uses or it is really an issue with credentials?
    
    Btw, Old laptop OS is Windows 10 Home, new PC OS is Windows 10 PRO. Does this affects Excel/PowerBI web data scraping?
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
  Microsoft
  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
    Copper Contributor
    Sep 06, 2017
    Thank you for following up. I have emailed some details FAO: Ehren.

Forum Discussion

Unable to Connect to Web Source With Credentials in Power Query

27 Replies

Resources