Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
keds2300
Regular Visitor

Using REST API as a data source

I'm trying to connect to a data source that uses REST API and can't seem to get authentication working.  In REST, this code works: 

BearerToken.png

 

 

In PowerBI, I've used the same URL and set the Authorization header with the same parameters and get the following authorization error: 

AccessError.png

 

What am I doing wrong here? 

3 REPLIES 3
Jayendran
Solution Sage
Solution Sage

Hi @keds2300 ,

 

Please see my exisiting answer below

 

https://community.powerbi.com/t5/Developer/Dataset-not-refreshing-via-API-in-Power-BI-web-service-am...

 

By directly this is not achieveable however using gateway as a workaround this can be achievable !

Hi @keds2300 

 

check Chris Webb's Blog.

https://blog.crossjoin.co.uk/category/power-bi-api/

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Thanks, but the post has information about creating a custom connector for the Power BI REST API.  I'm trying to connect to a another application's API.  Can I not do that directly from PowerQuery or do I need to create a custom connector as well?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.