Forum Discussion
Row Level Security - best approach?
Hi there, So I have this situation where I will have 10-20 roles to manage in PowerBI. There will be 10 tables or so to filter for each role and I am not able to easily create a Single "Role Tab...
Hi campelliann,
In fact, RLS and filters work on different levels, you can't use the selection from the slicer to dynamic effect the RLS.
Notice: the data level of power bi(from parent to child level)
Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table,RLS) -> data view with virtual tables(measure, visual, filter, slicer)
Regards,
Xiaoxin Sheng