Forum Discussion
Importing Data using legacy Web Connector in Excel
Hi Tim,
There are no plans to remove the legacy wizards from Excel. They are just hidden from the ribbon, but you can bring them back if required.
Regarding the "secure" comment, then Power Query supportד various modern ways of authentication - Basic auth, OAuth, Azure Active Directory authentication and more. Some of those are not supported in legacy wizards.
Regarding Web.Page() authentication, then I assume you are talking about Form Authentication, right? Well, if this is the case then the best way to influence will be to vote for this idea on Excel or PowerBI User Voice. This helps וד to prioritize our resources.
Guy
- Excel Team
re: Web.Page()
I mean http basic authentication - as that is what is used to do and it worked very nicely with the http-basic auth I implemented in our application.
I have some votes on the suggestion at: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/31900633-re-enable-authentication-capability-for-the-powerq?tracking_code=78da0284d128c9a8a4574b644805666d
Thanks,
Tim
- Guy HunkinDec 26, 2017
Microsoft
Power Query supports Basic authentication out-of-the-box. Am I missing something?
- Tim ScottApr 25, 2018Copper Contributor
Guy,
In the post at: https://social.technet.microsoft.com/Forums/ie/en-US/f3099495-eba9-4600-85c5-131257564c82/get-data-from-web-with-authentication-connection-error?forum=excel
your Microsoft colleague (Jeff Reed) posts:
"The newer experience uses Power Query for retrieving the web page. Specifically the From Web experience is using the M function Web.Page. Web.Page uses IE to read the webpage, and IE does not give the ability to compartmentalize cookies, which could present a security risk of leaked cookies. To prevent the security risk Basic Auth and OAuth are prohibited with Web.Page.
The team knows that this is painful and is actively working on a solution to provide a better experience."
To be able to continue to use the basic authentication and to be able to modify the URL programmatically in the .xlsx file, we will continue to use the legacy wizard.
Thanks,
Tim
- Tim ScottDec 26, 2017Copper ContributorBasic authentication is needed with web.page() to allow massaging of the URL programmatically in the xlsx file.