Can we have two sets of row level security in Power BI

[Anonymous]

Hi Experts,

Please let me know if this can be achieved in Power BI or not.

We have a table "RegionSecurity" in the database which has a list of user email adderesses mapped against Region code. This table is joined with Region dimention with Row level security.

We have another dimenstion "Process Status", which state the data is one, could be draft stage, Partial stage, Final stage.

The Process Status has AAD groups and roles assigned to them.

When the user open Power BI we want both sets of Row kevel security to apply.

Please suggest if this is possible in Power BI.

[v-eachen-msft · Accepted solution]

Hi, @Anonymous 

If you used Import mode, you should set row level security with USERNAME() or USERPRINCIPALNAME() functions,

For example:

If you used live connection mode, you need to do that within the Analysis Services model. You can't define roles within Power BI Desktop for Analysis Services live connections.

Please click the following link if you want to learn more :

https://docs.microsoft.com/en-us/power-bi/service-admin-rls#using-the-username-or-userprincipalname-dax-function

Best Regards,

Eads

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

[Anonymous]

Hi @v-eachen-msft ,

Thanks for your reply.

We are using the Import mode. Here the issue is can we have different sets of row level security. As i described, 

We have a table "RegionSecurity" in the database which has a list of user email adderesses mapped against Region code. This table is joined with Region dimention with Row level security.

We have another dimenstion "Process Status", which state the data is one, could be draft stage, Partial stage, Final stage.

The Process Status has AAD groups and roles assigned to them.

When the user open Power BI we want both sets of Row kevel security to apply.

Thanks and regards.

[v-eachen-msft]

Hi @Anonymous ,

If you use Import mode, you cannot use two sets of row level security. The RLS in database need to be set in Power BI.

Best Regards,
Eads

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

[Anonymous]

Hi @v-eachen-msft ,

Many thanks for your reply.

We are using an Import mode. Can you please add more details to your answer.

Thanks.

[v-eachen-msft]

Hi @Anonymous ,

Here are the links of setting RLS in Power BI, you can refer to these documents.

https://docs.microsoft.com/en-us/power-bi/desktop-rls

https://docs.microsoft.com/en-us/power-bi/service-admin-rls#using-the-username-or-userprincipalname-dax-function

Best Regards,

Eads

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