Forum Discussion
Role level security combined with dataflows
Hi all,
In our organisation we are more and more making use of dataflows which our users can use to build their reports.
Based on the dataflow we can control what data attributes they have access to to make sure that every user can access the same data. We prefer making use of dataflows over datasets since dataflows can also be enriched with other data sources, grouping can be done, the data is visible etc. etc.
However, occasionely we have dataflows with different business lines information and not every user is allowed to see all business lines.
What sort of options do we have to make just 1 dataflow which will still show only the data the user is allowed to see. So basically Role Level Security on the dataflow itself. Looking forward to your thoughts since we are struggling with this one quite a bit.
Many thanks in advance!
1 Reply
Dataflows don't support RLS. They are just tables as far as Power Query is concerned. You need to do all RLS in the combined Power BI desktop (create roles) and service (assign roles).
If you create dataflows and give access to devs, they can see 100% of the contents of the dataflow. If you need to restrict it, you'd need to create multiple dataflows and give the respective devs that they are allowed to see.
