Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
rebecka
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?

 

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.