Showing results for 
Search instead for 
Did you mean: 
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: 




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



What am I doing wrong here? 

Solution Sage
Solution Sage

Hi @keds2300 ,


Please see my exisiting answer below


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

Super User
Super User

Hi @keds2300 


check Chris Webb's Blog.




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 work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"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

Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors