Forum Discussion
RLS help!
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.
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 ?
Hi Anonymous ,
I don't think so. Why you don't want to create multiple role?
Best Regards,
Jay
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!