Tabular Model Different RLS for Different Reports

[Anonymous]

Hi All,

I have a SSAS tabular model setup with existing RLS. I have developed a new Power BI report that requires a different set of RLS filters to be used. Is there any way to accomplish this without turning the report into Import mode or creating a new cube?

Essentially, we need all users to only be able to see their data for this report, instead of managers and above having access to all data.

One thing that I have already tried is using a measure to filter the Staff table and applying it to visual filters within Power BI

CALCULATE(COUNTROWS(Staff), FILTER(ALL(Staff[StaffUserName]), Staff[StaffUserName] = USERNAME())) + 0

But this does not work on all visuals within Power BI and seems like a sub-optimal solution.

Cheers

[SivaMani · Accepted solution]

@Anonymous,

You have RLS implemented in the Report Source( SSAS Cube). You can't modify the RLS created in SSAS Cube from Power BI in a Live Connection. You can either do it with import mode or modify the existing Cube.