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.
This is a RLS question: I need to show the user’s own data and also Totals; but NOT data from any other specific user.
I have my Fact table with several measures, and my Users dimension (DimUser)
In the FILTERS, I have a “user name” filter, where all users shall select only see themselves. (there’s a few super-users who should select among all users…)
On my .pbix I show 2 visuals:
I am able to do this because I use DAX’s REMOVEFILTERS function.
How can I do the RLS I need? The user accessing shall see her/his own data and also totals; but not any other user specific data.
I am already doing the RLS in the USERS dimension using [username]= USERNAME() but of course, its filtering all the way to my fact and my Visual2 gets messed and both visual display on the user's data...
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |