Workspace RLS and Access Database

[rqueiroz]

Hi,

I need to analyse all the access of my Workspace, so I would like to know if there is any way to download a database with all RLS, Dashboard Access Permissions and Shared from my Workspace, with the e-mail user and the dashboard and RLS that he has access.

It should be simple, since controlling access from dashboards is something very usefull, but I didn't find a solution or an idea for that.

Thanks. 😃

[ibarrau]

Hi. You can check the activity logs (Rest API) to understand the email of the users with specific operations to different items like "email@example.com has an operation view report X".

You can read more about it here: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing

On the other hand the RLS is a lot more complicated. I don't think you can check that in the logs. The only way would be if you have a base of knowledge with all users and their roles to join or merge with the activity log data.

There is also a "Usage Metrics" option for a report that you can edit and change for the workspace. However I'm not sure you can check user by user inside that data.

I hope that helps,