Need help with understanding row level security in a very simple PBIX

[Redraidas1]

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:

https://easyupload.io/jlc3ro

[Anonymous · Accepted 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.

[Greg_Deckler]

@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:

• KPIs Locale: [Locale] = 1
• Trading Summary Locale: [Locale] = 1

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.

[Redraidas1]

@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!