We recently did a poc on Power BI but reach an dangerous limit of RLS feature. As we manage data from 2 organisations, we have 3 kind of user : User with access to org A; User with access to org B; User with access to both; For now, we created a dataset using RLS to filter out the (confidential) data the 2 first set of user can't see... However, these user are the "Power User" of their organisation, and become our main content author. I setup a workgroup including Power User from the 3 groups as they collaborate a lot, I tried the following combinations without success : Every members of the group can Edit Content : Bypass RLS Every members of the group can See content : Can't create new report Every members of the group can See content but is Admin : Bypass RLS For now, we "fixed" this by filtering out the data from the dataset itself and create 3 groups, but it's unmanageable for maintenances ! Will it be possible to include RLS for content author ? I think the ideal scenario should be : Every members of the group can Edit Content but can only see data AFTER RLS is applied ! Thanks !
5 Comments
- I have the same problem in a I recent release of some reports and datasets included as part of a workspace. I need an editable workspace because my Power Users will need to connect to online datasets from Power BI Desktop.
- I have exactly the same problem. We are a large organization in which Power Users must be able to create reports and dashboards but must also access segregated data. This is impossible to accomplish today. Today the users are either 'Viewers' and the RLS is applied or anything else and RLS is circumvented. It makes no sense to me and I'm amazed that this defect is not given more attention by the developers. Thanks.
- I have the same problem as well. As a big company, we really need this feature in Power BI as it is crucial to provide edit access to users after applying RLS. We are not able to find a workaround for this and this is a big limitation in Power BI Service today. Hope this idea will be implemented the soonest possible in Power BI. Thanks!
- Like others, I am perplexed why there is not an option to "always apply Roles" to a dataset. The only alternative for a shared data source is to use Analysis Services and build the RLS into the cube. This is a huge hole in an otherwise good feature within Power BI.
- Status added:Needs Votes
