Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
Hi @keds2300 ,
Please see my exisiting answer below
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.
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 - Power BI Tutorials
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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |