Forum Discussion
Unable to Connect to Web Source With Credentials in Power Query
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
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
Tim Scott, it's not necessarily a one-off solution. If your Web site uses cookies to avoid logging in each time like mine does, the solution will work until the cookie expires, at which time you will have to reuse the Legacy wizard to log back in again.
I have just tried this. Used the legacy wizard to disconnect from the site, at which time the power query stopped working. Logged back in again via the Legacy wizard and the query started working again.
- What I believe you end up with, here, is the credentials stored in the background "IE session" that Excel is using - and then reusing for the non-legacy wizard.
As a one-off, it's a good solution.
For my situation, I wanted a perpetual or repeated login to operate month after month and to be able to write up a "how to" for our customers who are not so savvy. DeletedI got it working!
Steps to reproduce:
- Enable Web (legacy)
- Get data/Legacy wizard/Web
- Type the URL you want to access
- Enter your credentials on the login page and press Login (or equivalent). In my case, the Login button did not seem to be working. I press several time, but nothing happened - not an issue it seems (see below).
- Press Load. This will load the content of the page you're trying to access directly in Excel. Not really usable, but we are just using this step to get the login credentials into Excel.
- Now we can do: Get data/From other sources/From Web
- Type the URL from step 3 and press OK.
- Select the table you are trying to access and press Load.
- That's it!
The trick really is that you use the legacy wizard to store the password that is then somehow used by the non-legacy wizard... Weird!
Ehren von LeheMicrosoft
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
Ehren von Lehe Yes, new PC PBI was from Microsoft store. I re-install PBI using the installer, and now it is able to get the table/s. Though still confused because credentials are still invalid, but when I selected anonymous, it worked...
Old PC has Aug2019 version, new PC has Sept2019 version (not sure if this is the numeric versions you were asking..)
I think, it is the installer versions solved the issues. Thank you very much for this.
Regarding EXCEL query, it is also now working... I didn't change any settings. I just tried if the other option for "From Web" function under "Get Data>>From other sources>>From Web", and fortunately succeeded (not sure if this was really the solution...). On this one, I used credentials and was accepted.
Thank you All for your help...
- Ehren von Lehe
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
Toynk Accounting sadly that didn't work as well.
I remember in the past when I was working in the old PC for the same thing, I was able to enter credentials (Username & Password), and after that, query shows all the tables I needed (that was Aug-Sept 2018). I really do not understand why credentials entry are currently not working properly.
