Connect to Web Authentication

[rwhit]

I am trying to connect to a website where a portion of the data is behind a username and password. However, Power Query is unable to log in. Any help is appreciated.  

[bharath8]

try using browser authentication  

[Anonymous · Accepted solution]

Hi @rwhit ,

A site that uses Forms authentication is probably not usable from Power Query (for now). If the site supports "Basic" authentication or some header- or querystring- based token, then it can probably be used.

You need to add an "Authorization" header to your web connector via the Advanced tab when you enter the url in Power BI. The authorization header accepts the Basic encrypted credentials that are sent when you login to that site in your browser.

Or you may use Fiddler to track the login information .Refer to:

https://community.powerbi.com/t5/Desktop/Connect-to-a-website-that-has-credential/td-p/21215/page/3

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.