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 need to be able to apply row level security and I have the following structure:
With the following permissions:
And this works to filter the reports by user, if userX belongs to companyY, but we need this to work with user X being able to see companyY and companyZ, how do you do this?
Its also worth mentioning that I got this working by following this video:
https://www.youtube.com/watch?v=ywNx7Cn1aZU
Which comes from microsoft but it says its now outdated, so I assume that there is a better way, can someone point me to the right resource? Thank you!
Solved! Go to Solution.
Looks like you need to make your User to UserTenant relationship bi-directional or at least have the User table filter the UserTenant table. Then if a user is in more than one tenant it should work. Alternatively, have your RLS rule based upon UserTenant instead of User.
Looks like you need to make your User to UserTenant relationship bi-directional or at least have the User table filter the UserTenant table. Then if a user is in more than one tenant it should work. Alternatively, have your RLS rule based upon UserTenant instead of User.
Doing both changes worked, thank you!
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |