A great add over Row-Level Security could be Page-Level Security: granting some access to report pages selectively to some users.
Currently possible workarounds include either bookmarks/page navigation/conditional formatting (making the font transparent) and can be quite easily worked around by savvy users (by drillthroughs, sharing the link to a given report page directly etc).
I propose an approach and framework that is more robust and user friendly. Current demo of the solution relies on a combination of a user-page mapping table, RLS, page-level filters and a calculation group. This is possible to implement already in Power BI as outlined in tutorial: https://www.youtube.com/watch?v=g7_Yt4u8tBk&t=2s
This could be made even more user friendly and intuitive if the idea would make it to the development roadmap of Power BI.
Parts of the current framework for PLS could likely be reused / be an inspiration / have an UI put over them to make them more user friendly:
- assigning roles/users to an automatic list of pages,
- choosing the behaviour of what happens when a user goes into a page they don't have access to - blank out all the visuals, return errors etc. Currently this is handled by a calculation group.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Dynamic current-period defaults for separate Year and Month slicers
Scenario The target scenario is a report viewed in Power BI Service, using a DirectQuery semantic model and a dedicated Date dimension. Separate Year and Month slicers are part of the required user ...vvargasv2 days agoMicrosoft EmployeeNew13Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf2 days agoFrequent VisitorNew74Views3likes3CommentsAdd REST API to Take Ownership of Fabric Pipelines
When using service account to automatically deploy Fabric pipelines from Dev workspace to upper environments, the owner of pipelines in target envionment remain unchanged. In some situations, per...VickyPeng2 days agoRegular VisitorNew367Views5likes2CommentsUpdate the 'Users can set up email subscriptions' in Fabric Admin Portal to specific groups
I want to be able to allow a specific group of users to set up email subscriptions. In my admin portal view I only get the following Can this be updated to allow specific user groups? ...Chart682 days agoNew MemberNew138Views1like1Comment