Hide Field parameter dimension using User role

rob_vander2 

Create a measure to dynamically filter the field parameter based on the user's group:

SelectedDimension =
VAR CurrentUser = USERPRINCIPALNAME()
VAR UserGroup = LOOKUPVALUE('User'[Group], 'User'[User], CurrentUser)
RETURN
SWITCH(
UserGroup,
"A", "Country",
"B", "State",
BLANK()
)

 

Use the measure to filter the field parameter in your report. You can use this measure in a visual level filter or in a calculated column to dynamically show the appropriate dimension based on the user's group.

 

 

Build and test in Power BI Desktop first ok.

 

If it then does not work in Power BI Service then there are usually 2 reasons:-

 

The users should only have Read access to the dataset and workspace, otherwise they can override RLS.

 

The users needs adding as a member to the security group.

 

• Please accept the solution I gave you because it does work 100%. You are now drifting into a new question about Read access. Thanks.

 

Learn about RLS here

https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security

 

 

Hi rob_vander2 

 

Please can you click the thumbs up button and accept the solution.

 

I provide a solution with example and text screen shots proving it works 100%.

 

Please follow the instruction I provided to build and test RLS in Power BI Desktop first. If it does not work in Desktop then copy the logic more carefully and it will work !

 

Then publish to Power Bi Servce and add the users to the security role.  Learn how here

https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security#validating-the-role-within-the-power-bi-service

 

Then validate it in Power BI Service using "Test as role". Learn how here
 https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security#validating-the-role-within-the-power-bi-service 

 

If it does not work then it is because your users have the incorrect permissions.

RLS only restricts data access for users with Viewer permissions. It doesn't apply to Admins, Members, or Contributors. Go into the Power Bi Service and look what access the user have to the workspcae and dataset, and edit them accordingley.

https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security#validating-the-role-within-the-power-bi-service

 

Then ask the users to try with their own login.

If it does not work, then wait at least 1 hrs for the Power BI Service to replicate the permissions changes in the cloud.

 

If it still does not work then check the user error message carefully. Do they have license?

 

Thanks