Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Solved! Go to 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
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-...
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?
SOLVED
I had to use "Anonymous", "Organizational" and skip connection test
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.