Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm unable to figure out how to setup row-level security on multiple dimensions for a model as described/shown below.
I've tried to provide as much detail as possible with sample data that pretty closely represents the actual model. I know how to setup dynamic security for just the Org piece but both the Org and Project is where I'm struggling.
Would appreciate any guidance on how I could make it happen.
Here's a link to a sample model I created in Power BI -> https://file.io/Ty9Nem
Solved! Go to Solution.
No, it's not possible to achieve this kind of RLS. We can only apply dynamic row level filter to limit access based on "1 to 1" mapping which can be achieved with LOOKUPVALUE(). However, we can't have this dynamic security across more than two tables.
For example, you can get the Org ID based on accessing user. Then you can still get another column value with LOOKUPVALUE() based on these "filtered" Org ID. But you can't go any further to map next column.
Regards,
No, it's not possible to achieve this kind of RLS. We can only apply dynamic row level filter to limit access based on "1 to 1" mapping which can be achieved with LOOKUPVALUE(). However, we can't have this dynamic security across more than two tables.
For example, you can get the Org ID based on accessing user. Then you can still get another column value with LOOKUPVALUE() based on these "filtered" Org ID. But you can't go any further to map next column.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |