The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
We have a requirement where we want to filter the datasource of the dashboard based on the Region of the end user. FOr example if a user in the US opens up the dashboard then the datasource(SQL view) should be filtered with condition where Country="US" and if the user from UK opens the dashboard then the filter should change accordingly. We have the country as one of the available columns as well in our DB.
We tried using RLS but that involves assigning each user of the region to the corresponding role which would be very tideous in large number of end users.
1. Is it possible to assign RLS role to a office 365 group which includes all the end users.
2. Any other inputs would be of great help.
Thanks
ThreeAtion
Hi,
This sounds like you have tried static RLS but there is also a dynamic variant that should help you in this scenario. There are plenty of detailed articles or videos on the web when you search for this term so you should easily find it, ie.
https://community.powerbi.com/t5/Community-Blog/Dynamic-Row-Level-Security-Dynamic-RLS/ba-p/787399
Good luck with the implementation!
Tomek
Hi @t0mek
Thanks a lot for your response. Dynamic RLS still requires to map everyone one in the organization to the single role that will be created using the Power BI security feature. Please advise if understanding is correct.
Also is it possible to create a office 365 group with all users like all@company.com and assign this group the role so as to avoid individual role assignment?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |