Forum Discussion

rwhit's avatar
rwhit
New Member
4 years ago
Solved

Connect to Web Authentication

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.      
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.