Forum Discussion
RLS help!
I have a table "RLS" with two columns Department and User ID. I have a requirement where when a user logs in Power BI service they should only see data related to their department . Eg [email protected]...
Hi,
You can create multiple roles in Power BI desktop. So in your example you might want to create the following roles:
- Department: This is where you set up your RLS as specified below. Filter user ID = Userprincipalname()
- All: Create a role that does not contain any filters.
When you publish your report to Power BI service, you can add users [email protected] and [email protected] to the "All" role, and no filters will be applied when they access this Power BI report.
Thanks for the response , is there a way to use if else condtion in the same role ? instead of creating two roles ?
Not that I'm aware of. Creating a new, blank role for any users who should see unfiltered data would be the simpler option.
Thanks for the solutions!