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.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 63 | |
| 50 | |
| 46 | |
| 41 | |
| 39 |