DAX for RLS?

[Anonymous]

Is there a way in DAX to achieve the below?

I have a model with tables:

-Revenue.

-CostCenter.

I have RLS set up for two special users, that I take their USERNAME(), and I give these two users access to a specific sets of CostCenters.

Now, I am creating a new PowerBI,  and I am trying to reutilize the same cube.

But, the access is based on another table named ‘Contract’, so these same two users shall have access to a set of contracts.

Can I have a way of using 2 Power BIs, pointing to the same cube, and in one report they shall see CostCenters x,y,z and in the other Contractoz a, b, c?

Or is it more convenient to just “copy paste” the entire cube (use 2 cubes) and do the RLS on each one. (I also ask this in terms of future mainteanance).

[v-angzheng-msft]

Hi, @Anonymous 

RLS set for one shared dataset will take effect for all the related reports.

Different reports based on the same dataset have the same access control for row-level security.

Copy-pasting multiple datasets for different permissions is a workaround, it's not an elegant solution, but it works.

Best Regards,
Community Support Team _ Zeon Zheng

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