Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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.
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 20 | |
| 19 | |
| 13 |
| User | Count |
|---|---|
| 60 | |
| 52 | |
| 47 | |
| 40 | |
| 38 |