Display RLS in force when user views report

[johnnypantera]

Greetings!  We have a PBI Report with RLS that is published to the PBI Service.  When users access a report we would like to visibly show them the RLS in placed for their personal view (much like they can see report filters in play), so we can avoid users lack of clarity regarding the organizational data slice they are viewing.

If someone could share the PBI feature and/or DAX code to make this happen, I would be very grateful.  Thank you in advance.

[v-diye-msft]

Hi @johnnypantera ,

I'd like to suggest you looking through below references whick much helpful:

Official document mainly about the static RLS: https://docs.microsoft.com/en-us/power-bi/desktop-rls

Dynamic RLS:https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

[Anonymous · Accepted solution]

Hi @johnnypantera ,

This is what I would do:

1. Create a table (let's call the column RLSName) in Power BI that has rows with your RLS names, e.g. Row 1: Manager, Row 2: Employee
2. Assign the RLS you created previous with an "Or" statement (which I believe is the syntax || ), with the values equals to the RLS values (just like how you create RLS, but this time with the RLSName)
   • e.g. Role "Manager" >[RLSName] = "Manager"
   • e.g. Role "Employee" >[RLSName] = "Employee"
3. Create a new visual that will show you the RLSName, so if someone is assigned Role Manager, he/she will see "Manager" in the visual

Hope this works and hope this helps!

Daren