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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I want to connect to Power BI rest API via azure the api permissions have been set up, but I want to connect via Power BI to get all the organisations Power BI service data, does anyone have any instructions to set this up. I was thinking of doing a power automate to parse json but it's not working. The permissions have been set up as a service principle and not an individual user
Hey @knowledgesearch ,
how did you handle the security?
Are you generating a bearer token with the service principal and use that in the header of the connection?
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Connect with me: LinkedIn
The security was set up by IT, How would I get a bearer code? where is that listed on the API permissions.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 58 | |
| 52 | |
| 40 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 111 | |
| 109 | |
| 40 | |
| 33 | |
| 26 |