List all RLS roles I have

[user10456]

Is it possible to get a list of all the RLS roles I have been added to, across all semantic models? I haven't seen any mention of this online, but I would like to know if it's possible.

For context, I'm more worried about other people doing this than about doing this myself. I am planning to add a whole-organisation distribution group to an RLS role where only a small subset of those users will have access to the reports based on these semantic models. I want to know whether users can see that I've done so.

[ibarrau · Accepted solution]

Hi. I don't think there is a UI way of doing it. In this case you could using the Power Bi Rest API. You must have fabric admin permission to the user or the tenant setting for giving admin api to a Service Principal.

You can get all this with the Scanner API. However it can be tricky. I would try SimplePBI. It's a python library that makes it easy and it has a request for getting all the roles in a dataset or get all the roles in all datasets in a list of workspaces.

If this is your first time you can read something like: https://blog.ladataweb.com.ar/post/740398550344728576/seteo-powerbi-rest-api-por-primera-vez

That should give you a get started. Here the library: https://pypi.org/project/SimplePBI/

I hope that helps,