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
Allow Managed Private Endpoint to be disabled/enabled per notebook
Could notebooks have an option to use or not use the workspace's Managed Private Endpoint (MPE)? MPE can significantly increase notebook startup time, even for notebooks that don't need private conn...frithjof_v1 hour agoCommunity ChampionNew13Views1like0CommentsJustification Prompts When Downgrading or Removing Sensitivity Labels in Power BI Desktop
Description Currently, organizations can configure Microsoft Purview sensitivity label policies to require users to provide a justification when removing a label or lowering its classification. T...vvargasv17 hours agoMicrosoft EmployeeNew11Views0likes0CommentsVisual Type Defaults in Visualization Pane
This would change my life with fussy clients and client/public facing apps. In addition, it would allow me to add more value to the clients on retainers who do not have the 'hours' to allocate to...IolaWhiteley18 hours agoAdvocate IINew53Views7likes0CommentsMatrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente18 hours agoRegular VisitorNew79Views6likes1CommentAllow Bookmarks to Affect Multiple Report Pages
Description: I would like to request the ability for a single Power BI bookmark to affect and maintain a state across multiple report pages, rather than being limited to a single page. For example,...Josegonzalez2118 hours agoNew MemberNew20Views4likes1Comment