cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rebecka Frequent Visitor
Frequent Visitor

Hide dimension members which the role isn't allowed to see, RLS in SSAS MD and Power BI Embedded

Hi,

I've created a Power BI Embedded report with SSAS Multidimensional as data source and dynamic RLS with CustomData as authorization. I pass the organization's id to the report so it can be filtered by that, so each organization can only view its own data!

But in the report I have a filter/slicer on other dimensions which isn't filtered by the organization's Id. For example: organization users, other organizations can see my users even though they don't have access to that data.

If I try to browse data for a user NOT in my organization I get no data, but I can still see the user name as option.

Does anyone know how to fix this?