Connect to Web Authentication

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.