Forum Discussion
Unable to Connect to Web Source With Credentials in Power Query
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
- Toynk AccountingSep 29, 2019Copper Contributor
Deleted first of all, it looks like the query on your old PC hasn't been refreshed in months. From the Query Editor, click on REFRESH ALL and see if it still works. If it does work, click on the Web View tab and post a screen shot of both PC's (redacting any sensitive info of course). Lastly, click on Data Source Settings on the Main tab in Query Editor and then Edit Credentials. See how the old one is set-up compared to the new PC. I'm not convinced your problem is authentication or that your problem doesn't exist on the old PC. This will prove or disprove, I think.
Tim Scott's legacy wizard suggestions are not at all what you're looking for. the legacy scrape is far inferior and you old PC was not using legacy. Not sure why it's even being suggested.
To answer your question to me, I did figure this out - somehow. Can't recall exactly. But it had something to do with typing my password into the API credentials, I think. I can't quite recall but it wasn't an obvious move. After 2 years with no answer, I just started trying things and it worked. Did it for a few other sites, didn't write it down, now I can't remember.
- Tim ScottSep 29, 2019Copper Contributor
Well - the legacy wizard solved my problem. If that's not the answer, either Microsoft have changed something in two years or it's a different problem.
- DeletedSep 29, 2019
Toynk Accounting I just click REFRESH ALL in old PC and it is still working.
Below screenshots of each Navigator Web View (Seems like Internet Explorer is causing the error?)
NewPC_WebViewOldPC_WebView
Regarding Data Source Setting, both are same and was reference to old PC
- Toynk AccountingSep 29, 2019Copper Contributor
Deleted interesting. I guess try and turn off the Internet Compatibility settings. Otherwise, I'm a at a loss. Sorry can't be of more help