Getting data from web page using windows credentials

[SNishimura]

Hello All,

I'm encountering problem to get data from webpage using Windows credentials in PowerBI/ PowerQuery.

My data source is a coorporate web page (table), which requires Windows credentials to log in.

When I select "Get Data>Web", enter the webpage URL, select "Windows credential" from the "Access web content" menu, PowerBI/PowerQuery returns me an error stating "web.browsercontents currently supports only anonymous credentials"

If I select "Anonymus" credentials instead, it returns an error stating"We couldn't authenticate with the credentials provided"

The strange thing is that I didn't had any problem to "Get Data>Web" using windows credentials until Jan 2020, I doubt if any changes were made on Power BI side lately with the updates.

I also noticed that if I manually enter = Web.Page(Web.Contents("WEBPAGE_URL")) in the formula bar, Power query can access to the webpage and retreive the table successfully. Datasource setting is configured to use the windows credentials. Once the table is loaded, I don't have any problem refreshing the data using PowerBI/PowerQuery.

So, the problem seems to be limited when I'm trying to get data using the "Get data> Web" Navigator.

Did anyone experience the same symptom? Is that a bug?

Regards,

[Syndicate_Admin]

Today, April 7, upgrade to the latest version of Power Bi desktop and encounter the same error, try the @v-easonf-msft solution but it didn't work, has anyone found another solution?

[v-easonf-msft · Accepted solution]

Hi, @SNishimura 

This issue has been  recorded and resolved .

The old Web import flow used Web.Page, which supports non-anonymous creds. The new Web import flow uses Web.BrowserContents, which only supports anonymous creds. You can continue to use Web.Page via M if you like, and any old queries that use Web.Page will continue functioning. If you want to switch back to the old Web import flow, you can do so by disabling the "New web table inference" preview feature in the Options dialog.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.