Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

(HARD) RLS with org. hierarchy

Greeting fellow Power BI enthusiastics!     I have a really hard RLS solution, yet to be completed, which I need professional help with :-) Lets get right into it,   In my model I have the follo...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

Anonymous

 

Based on your description, you want to apply row level security on User level to get the unique related Customer. Then filter the Booking Cube based on this Customer's Level. Right?

 

If you build the relationship between BookingCube and Customer table, it will only filter the corresponding  Customer with level you selected. We can't apply IF() condition to check the Customer level because the row level filter expression will not determine current row context from other table, even one User has only one related Customer. If you delete the relationship between BookingCube and Customer in order to filter the all Level data, the filtered table context will not be passed to BookingCube.

 

In this kind of multiple table scenario, the filtered table context for row level filter can only be determined with existing relationship. We can't break the existing relationship to delegate filter context manually for custom logic. For your requirement, it can't be achieved.

 

Regards,