Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data via web source with login credentials

Hi all,

 

I wandered the whole PowerBI community and saw that a lot of people have the same problem with getting data from the web (as soon as web page requires a login). When you walk through all the correct stepts (source > web > place URL > give credentials login/pswrd), then the reply is: "The given login credentials are not valid". 

 

I am sure (just like a lot of different people) that the credentials are correct. If i am logging in that URL with my credentials via browsers, i get results :).  Does anyone allready have found a way to make this work? Or is there a workaround which i can try? 

 

Thanks in advance for your help!

Need Help
Tips and Tricks

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi mwegener ,

       

      web applications indeed manages the login itself. The link you encluded was a new insight and i have tried is that way. I do not get the error anymore, but i also do not get any results that i expect on the webpage. It is still an empty table which is returned without any recognisable column headers. 

       

      Ps. "anonymous authentications" is activated.

       

      In the step;

      "HTTP request header parameters" > i have filled in the "Authorization" my login name.

      I do not see any field named "password" (or something like that). I also do not see a field ÜS-customer-API-Key" as the instruction includes. So i tried several options to work around the password registration;

       

      • include no password
      • include password in authorization field (after username)
      • change anynimous authentication towards API key and include password there

       

      None of it works. Can i try anything else?

       

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    Hi , Anonymous 

    Yes, similar issues often occur.

    It really depends on the type of credentials, baisc auth, form auth, OAuth are handled differently.

    So it is recommended to check whether the website supports OData or which API it supports first . You can then decide which data source can be used to retrieve data in the Power BI desktop.

    If the website exposes a REST API, you can refer to this post to call it on the desktop. For OData feed, you may refer this post . 

     

    Best Regards,
    Community Support Team _ Eason