Using REST API as a data source

[keds2300]

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? 

[Jayendran]

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 !

[mwegener]

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.

[keds2300]

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?