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.
Hi everyone,
First of all thank you for looking into my question. I had RLS set up for my report and it was working fine, but for some reason it doesn't anymore. While it still filters the results on the access table that we have set up, it no longer passes these demands onto linked tables.
The role is set up like this:
The link between two tables is set up like this:
When I go into my report and test as the role I get the following result
Both tables use the exact same fields except that the left one also includes the e-mail field which is used to determine access. The moment the field is removed the data is no longer filtered.
How can I make sure the filters on the access page are passed onto the rest of the data?
Solved! Go to Solution.
Cardinality Should be set to "One to Many" instead of "Many to One" since your export table has single Plan and user table should have multiples.
Proud to be a Super User!
Click on "Apply security filters on both directions"
Proud to be a Super User!
Hi FarhanAhmed,
Thanks for your reply. I tried doing that, but it gives me an error
It says that because I use it for RLS I can't set the filter behavior for both directions/
Cardinality Should be set to "One to Many" instead of "Many to One" since your export table has single Plan and user table should have multiples.
Proud to be a Super User!
I think the problem is that we've turned the relationship into a many to many relationship while it used to be a one to many.
Right now we were giving rights based on programs, but it seems that we need to switch to giving rights to a cluster or programs instead. (or give the option to do so). That should probably fix it.
Thanks for the help, it made it clear where the problem was. I'll post to let everyone know if the fix that comes out of this will solve the problem.
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |