Power BI Desktop - Unable to pull from OData feed using Token authentication

[r_beacroft]

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

[r_beacroft]

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

[v-yuezhe-msft · Accepted solution]

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-...
http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/

Thanks,
Lydia Zhang

[bavix]

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?

[bavix]

SOLVED

I had to use "Anonymous", "Organizational" and skip connection test

[kdhawan]

Hey Bavix, I am trying to do a similar solution, maybe you did it in PowerBi Report Server Locally. Where did you set the Organizational option and skip the connection test?

Thank you 

[bavix]

Hi kdhawan,

I was activating the automatic refreshing in PBI Service, not in Report Server.