Data via web source with login credentials

[ezwijgers]

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!

[v-easonf-msft]

Hi , @ezwijgers 

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

[mwegener]

Hi @ezwijgers ,

what kind of login is it?

If the web application manages the login itself, you have to implement the login process and determine the "access token".

Take a look at this.

https://community.powerbi.com/t5/Power-Query/Pull-data-from-a-REST-API-Authentication/td-p/246006

[ezwijgers]

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]

Hi , @ezwijgers 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
More people will learn new things here. If you haven't, please feel free to ask.

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.

[ezwijgers]

Hi,

Problem is still excisting. I tried/used Fiddler but can not exactly find the WHY it is not working. So if anyone has any other ideas/work-arounds/possibilities to investigate, please fill me in!

Thanks in advance.

[mwegener]

Hi @ezwijgers ,

try to use Fiddler to understand the web communication.

https://www.youtube.com/watch?v=YHSTskjur8k