Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

A 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.

Reply
giorkatz
Regular Visitor

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.

1 ACCEPTED SOLUTION
Joe_Barry
Super User
Super User

Hi @giorkatz 

 

Within the Admin Portal you can see all workspaces.

Joe_Barry_0-1721727585617.png

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.

Joe_Barry_1-1721727644292.png


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

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Learn about the Star Schema, it will solve many issues in Power BI!

Date tables help! Learn more



LinkedIn


Let's connect on LinkedIn


View solution in original post

3 REPLIES 3
giorkatz
Regular Visitor

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Learn about the Star Schema, it will solve many issues in Power BI!

Date tables help! Learn more



LinkedIn


Let's connect on LinkedIn


Joe_Barry
Super User
Super User

Hi @giorkatz 

 

Within the Admin Portal you can see all workspaces.

Joe_Barry_0-1721727585617.png

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.

Joe_Barry_1-1721727644292.png


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

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Learn about the Star Schema, it will solve many issues in Power BI!

Date tables help! Learn more



LinkedIn


Let's connect on LinkedIn


Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.