List RLS rules in datasets

innocence84 — Thu, 29 Jun 2023 17:05:35 GMT

Hi,

I am getting list of datasets where row-level security was defined. (By using Power BI Rest API).

Now I am trying to show the RLS rules in all datasets.

How can I achieve this?

Thanks all

Re: List RLS rules in datasets

v-jianboli-msft — Mon, 03 Jul 2023 01:42:08 GMT

Hi @innocence84 ,

Unfortunately, there is no direct API to fetch RLS rules from the datasets. You will need to manually check the RLS rules for each dataset in the Power BI Service as described above.

To show the RLS rules in all datasets, you can follow these steps:

Use the Power BI REST API to get the list of datasets with RLS defined.
For each dataset, access the Security menu in the Power BI Service. This menu is usually under the "..." menu of a dataset in the workspace view, related pane, or the expand/collapse quick access section of the left navigation pane.
When opening the Security page, you should see roles and users and/or groups assigned to said roles.

Please note that only dataset owners can configure RLS roles on a dataset. They must be part of the workspace that hosts the dataset and have Write permissions on it.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic List RLS rules in datasets in Developer

List RLS rules in datasets

Re: List RLS rules in datasets