Forum Discussion
Admin portal
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.
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 reportshttps://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
3 Replies
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 reportshttps://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
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
