Forum Discussion
Power BI Desktop - Unable to pull from OData feed using Token authentication
Hi r_beacroft,
If you connect to OData feed using the following entry, and then enter your password, are you able to get desired result?If not, add a new blank query in Power BI Desktop, then paste one of the following codes in Advanced Editor and check if you get expected result.
let Source = OData.Feed("URL", null, [Headers = [Authorization = "Bearer Your token" ] ]) in Sourcelet Source = Web.Contents("URL", [Headers=[#" Authorization " = "Bearer Your token"]]) in SourceThere are a similar thread and blog for your reference.
http://stackoverflow.com/questions/33225590/authenticating-with-excel-power-query-against-net-odata-web-api
http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/Thanks,
Lydia Zhang
Hi,
Am newbie to Power BI.
We have an OData feed that supports token authentication.
i.e. requests contain a header with "Authorization Token [guid]"
How can I configure Power BI to be able to call ourOData feed?
Is this possible?
Kind Regards,
Rik
Hi r_beacroft,
If you connect to OData feed using the following entry, and then enter your password, are you able to get desired result?
If not, add a new blank query in Power BI Desktop, then paste one of the following codes in Advanced Editor and check if you get expected result.
let
Source = OData.Feed("URL", null, [Headers = [Authorization = "Bearer Your token" ] ])
in
Source
let
Source = Web.Contents("URL", [Headers=[#" Authorization " = "Bearer Your token"]])
in
Source
There are a similar thread and blog for your reference.
http://stackoverflow.com/questions/33225590/authenticating-with-excel-power-query-against-net-odata-web-api
http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/
Thanks,
Lydia Zhang
In Power BI Desktop it works fine. But after publishing and trying to schedule automatic refresh I don't get a connection. Edit credentials
What exactly do I have to provide in the credentials in Power BI Service?
I tried several methods with/without "" but get "The credentials provided for the OData source are invalid"
Status code: 400 I used:
Authentication method
Key
Account key
Bearer ........
Privacy level setting for this data source
Organizational
I also tried:
"Bearer ........."
What do I wrong?
