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.
Hello,
I've created an extremely simple report with only one visual for learning how Row Level Security works. I've added in some very basic role level security, however, for some reason the only visual that's in my report won't show any data as soon as I select 'View as' -> New Role. Can someone please explain why I cannot see any data in my visual with RLS applied?
PBIX:
Solved! Go to Solution.
Hi @Redraidas1 ,
Based on your description, you can do some steps as follows.
1. Create a calculated table and establish a relationship between new table and table “Report Config”.
Table =
VAR x1 =
SUMMARIZE ( 'KPIs Locale', 'KPIs Locale'[Locale], 'KPIs Locale'[Field Code] )
RETURN
UNION ( x1, 'Trading Summary Locale' )
2. Create a new role.
Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Redraidas1 ,
Based on your description, you can do some steps as follows.
1. Create a calculated table and establish a relationship between new table and table “Report Config”.
Table =
VAR x1 =
SUMMARIZE ( 'KPIs Locale', 'KPIs Locale'[Locale], 'KPIs Locale'[Field Code] )
RETURN
UNION ( x1, 'Trading Summary Locale' )
2. Create a new role.
Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Redraidas1 - Took a look. The reason is that you have two RLS rules and the combination of them eliminates all records from Report Config. Your two rules are:
The problem is that Locale = 1 in KPI's table is Field code 111 while Locale = 1 in Trading Summary table is Field code 333. Since those tables are related to table Report Code on Field code columns there is no case where there is a field code that is both 111 and 333 simultaneously and hence, blankness.
@Greg_Deckler - Thanks for that.
Would you have any solution for how to solve this problem? I want KPI Locale and Trading Summary tables to filter out my main (Report Config) table so that my Report Config table only shows Field Code 111 and Field Code 333. Or is that not possible?
Thanks!
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 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |