Hi
For a customer I'm creating a report in power bi desktop, wher RLS need be applied.
Have multiple tables, on some are applied RLS rules on some not.
The problem is:
on table A, where are stored all the user ID and the conditions for RLS filter (some lookup values, ...) (table A contains columns User_ID, Rule_ID, RULE_condition, lookup_values and more), i have set RLS based on the user ID. When i test the RLS, in this table i see only the rows that are valid for the user. this is working fine.
But i need from this A table select and copy those rows, which meet the criteria to other table B. Not create two reports, but to have two tables: Table A is the original table, with all the rows, table B is copy of the A, but contains only rows where USER_ID=Username().
The problem is, when i have written a DAX expresion for the table B, to extract table A, the table B contains all the rows (RLS filter is not applied). This is probably, because on the B table is not defined the RLS filter and there is no relation between the tables A and B.
THe Question:
How to filter the table A and create table B with filtered rows. How to retain the RLS filter, when creating the B table, but on B table i dont want to use RLS filter(it should contain only the rows, that match RLS filtering condition). Have used KeepFilters, but it is not working. I know, that i can put to the filtering expresion of B table condition for the USER_ID, but that what i do not want. Is there a other way how to keep RLS filters?
Thanks
