Forum Discussion
Unable to Connect to Web Source With Credentials in Power Query
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.
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
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?
Deleted From what I gathered, the new method did not handle authentication and the legacy wizards behave in the way they used to. At the risk of making a silly point, you did go to the legacy wizards option on the menu, not the option which now launches the new method, didn't you?
Tim Scott I went to Excel Options >> Data >> Show legacy data import wizards
Hope I did get you correctly.
Just for reference, below are Navigator snapshot using Power BI
PBI_NewPCPBI_OldLaptop