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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
DatDataNerd
Regular Visitor

Need a report for which reports security groups can access

Is there a way to grab a dataset of all of the reports in a workspace and see which users and security groups have access to them? Kind of like how you can grab a dataset of usage per report/user. Similarly , is there a way to run a report on which users are assigned to which 365 security groups? I hope this is the correct place to ask this but I'm not 100% sure where to look.

1 ACCEPTED SOLUTION
v-yetao1-msft
Community Support
Community Support

Hi @DatDataNerd 

1.You can through the REST API below to get the user or group that who can access the dataset by the dataset ID .Enter the dataset ID in the Request URL you will get the result you want .

Admin - Datasets GetDatasetUsersAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs

GET https://api.powerbi.com/v1.0/myorg/admin/datasets/{datasetId}/users

Ailsamsft_0-1640916952840.png

ailsa tao” is my security group ,you can see it in the return value .

Ailsamsft_1-1640916952843.pngAilsamsft_2-1640916952845.png

2.You cannot through a report to get the users that in security groups. Because we create security group and add users in the groups in Microsoft 365 admin center. If you want see the users in security group , you can sign in the Microsoft 365 admin center and see it in Home => Active teams & groups , with an administrator account .You can through the link below to learn more about users in security group .

https://docs.microsoft.com/en-us/microsoft-365/admin/create-groups/manage-groups?view=o365-worldwide

Ailsamsft_3-1640916952847.png

3.If you want to know which users accessed the report, you can learn more through these links below .

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-modern-usage-metrics

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics

Hope it will help you !

 

Best Regard

Community Support Team _ Ailsa Tao

View solution in original post

3 REPLIES 3
v-yetao1-msft
Community Support
Community Support

Hi @DatDataNerd 

1.You can through the REST API below to get the user or group that who can access the dataset by the dataset ID .Enter the dataset ID in the Request URL you will get the result you want .

Admin - Datasets GetDatasetUsersAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs

GET https://api.powerbi.com/v1.0/myorg/admin/datasets/{datasetId}/users

Ailsamsft_0-1640916952840.png

ailsa tao” is my security group ,you can see it in the return value .

Ailsamsft_1-1640916952843.pngAilsamsft_2-1640916952845.png

2.You cannot through a report to get the users that in security groups. Because we create security group and add users in the groups in Microsoft 365 admin center. If you want see the users in security group , you can sign in the Microsoft 365 admin center and see it in Home => Active teams & groups , with an administrator account .You can through the link below to learn more about users in security group .

https://docs.microsoft.com/en-us/microsoft-365/admin/create-groups/manage-groups?view=o365-worldwide

Ailsamsft_3-1640916952847.png

3.If you want to know which users accessed the report, you can learn more through these links below .

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-modern-usage-metrics

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics

Hope it will help you !

 

Best Regard

Community Support Team _ Ailsa Tao

Thank you, this info lead me to exactly what I need.

lbendlin
Super User
Super User

For Premium workspaces you can get this information from the tenant inventory logs (look for the "sharedTo"  attribute).  Talk to your tenant admin to get extracts.  If this is for personal or shared capacities then there's not really a way to get this.

Note that "access to reports" and "usage of reports"  are separate things.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors