Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Row Level security - Show report user which RLS role filters the report

Hi. I have a report that requires the use of RLS. Different RLS groups are assigned to the report. E.g I have these roles: EU <- Only data for EU countries US <- Only data for US Bicycle:...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi.

First of all - thanks for the reply. 
This will work as a solution in many cases.

Howevere. Do you have any ideas how to proceed if there are several filter columns?

For example, for the bicycle role, the proposed measure :

Regions = "Viewing data for: " & CONCATENATEX(VALUES('Table'[Region]),'Table'[Region],",")

will display all regions. But it should ideally show that the Product="Bicycle"

In other words, a measure or anything similar that enables to user to see his/hers active role:

Role to show user = 
// Pseudo code. 
CASE 
    WHEN ROLE IN ("EU", "US") THEN
        "Viewing data for: " & CONCATENATEX(VALUES('Table'[Region]), 'Table'[Region], ",")
    WHEN ROLE IN ("Bicycle") THEN
        "Viewing data for: " & CONCATENATEX(VALUES('Table'[Product]), 'Table'[Product], ",")
    ELSE
       "Unknown role"
END


Kind regards