Forum Discussion

Guy Hunkin's avatar
Guy Hunkin
Icon for Microsoft rankMicrosoft
Oct 18, 2016

Importing Data using legacy Web Connector in Excel

Hi all,   I have a question related to usage scenarios of the legacy Import from Web connector in Excel.     Today the legacy Import from Web connector supports the following features, ...
BI & Data Analytics
power bi
Guy Hunkin's avatar
Guy Hunkin
Icon for Microsoft rankMicrosoft
Dec 26, 2017

Power Query supports Basic authentication out-of-the-box. Am I missing something?

Tim Scott's avatar
Tim Scott
Copper Contributor
Apr 25, 2018

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

Resources