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 have a set of tables:
User table:
UserID USerName
======= ========
A AAA
B BBB
C CCC
Region table:
Region_ID Region_Name
======= ==========
1 Reg1
2 Reg2
3 Reg3
4 Reg4
Access_Details table:
Region_ID User_ID
======= ========
1 A
1 B
2 B
Details table:
Region_ID Date Status Flag
======= ======== ===
1 xyz 1
2 abc 1
1 abc 1
I need to limit access based on the User_ID. I tried creating a role on User table by specifying [User_ID]=UserName()
When i used "View as Role" and specified User_ID as A, nothing gets filtered.
Solved! Go to Solution.
Hi @vanessa,
I think you can refer to below article of dynamic rls:
Power BI – Dynamic Row Level Security – Tips to get it working!
Regards,
Xiaoxin Sheng
Hi @vanessa,
I think you can refer to below article of dynamic rls:
Power BI – Dynamic Row Level Security – Tips to get it working!
Regards,
Xiaoxin Sheng
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 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |