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.
Is there any possible way to have an output from PowerBI Service (for example a list or a table) that shows: User1 have access to workspace1, workspace2, report1, dashboard2, dataset1 | User2 have access to workspace1, workspace3, dataset3 etc. And then the other way around for example workspace1 : user1, user2 | workspace2: user1, user3 etc.
Solved! Go to Solution.
Hi @giorkatz
Within the Admin Portal you can see all workspaces.
When you click on the 3 dots beside the Workspace name, there is an option to see who has access and you can see the access level. This also translates to these users having access to the dataset.
Unfortunately there doesn't seem to be a way from the Admin portal to export who has access.
If you have access to the Power BI Rest API, you could export the data there.
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events This will get who has viewed reports
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-dataset-users Ths will show you who has access to a datset and their access levels
Take a look around the documenation and see if there is a relevant API that you can use
Joe
Proud to be a Super User! | |
Date tables help! Learn more
Thank you so much!! what about for each user to see where do they have access, is that possible?
From within the Admin portal, as mentioned, you can look at each Workspace individually and see who has access.
The API offers many options, take a look through them and see what is on offer
Proud to be a Super User! | |
Date tables help! Learn more
Hi @giorkatz
Within the Admin Portal you can see all workspaces.
When you click on the 3 dots beside the Workspace name, there is an option to see who has access and you can see the access level. This also translates to these users having access to the dataset.
Unfortunately there doesn't seem to be a way from the Admin portal to export who has access.
If you have access to the Power BI Rest API, you could export the data there.
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events This will get who has viewed reports
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-dataset-users Ths will show you who has access to a datset and their access levels
Take a look around the documenation and see if there is a relevant API that you can use
Joe
Proud to be a Super User! | |
Date tables help! Learn more
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 |
|---|---|
| 14 | |
| 10 | |
| 9 | |
| 7 | |
| 7 |
| User | Count |
|---|---|
| 33 | |
| 28 | |
| 26 | |
| 20 | |
| 17 |