Forum Discussion
Helper IIHide Field parameter dimension using User role
Dowload a PBIX solution from my Onedrive
Build your relationships like this and then click Manage Roles
Create a security role
Test by clicking on View As and sleecet the role and the Other User
Learn more about row level security and file parameter here
https://learn.microsoft.com/en-us/power-bi/guidance/rls-guidance
https://www.youtube.com/watch?v=NOgTiRitX8o
Please click thumbs up for these suggestions,
and click Accept Solution if any work.
Thank you
Super User
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