This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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.
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 25 | |
| 23 | |
| 22 | |
| 13 |
| User | Count |
|---|---|
| 62 | |
| 47 | |
| 27 | |
| 23 | |
| 19 |