Hello,
I am pretty new to Power BI and have made a design for shared datasets in my organization based on logic, but I can't get Row Level Security to work.
The design:
A central workspace with centralized shared datasets like Dim_Company and Fact_Hours
A shared dataset with a RLS table, columns user and project. In this dataset I implemented RLS.
The users can view the workspace and have build permissions on all datasets. I want to reuse Fact_Hours a lot, so my plan was to take the RLS table and add it to Fact_Hours. Here we get to the first problem. When I link these tables I don't get the option to apply security on the relationship. My next try was to import the RLS table into Fact_Hours and setup row level security this works.
But reusing this dataset in other models introduces the same problem, other tables are not filtering based on the RLS table because the option to apply security is not there. RLs is not propagating.
I know composite models are quite new, but this propagating functionallity seems essential for Enterprise moddeling. Am I missing something? Setting everything up RLS in all the final datasets will introduce a lot of maintenance.
I can't find a PBI Idea for it, so probably I am doing something wrong. Any help will be much appriciated.
