Steve Thompson on 15 Jun 2018 20:37:20
It would be useful to be able to hide columns or even pages based on who is looking at the report.
We can access the UPN and link this to organisation and role data.
It would save having to produce and maintain multiple reports that you'd be applying security to anyway.
Unless someone has come up with something cunning based on bookmarks!
- Comments (2)
RE: Hide columns or pages based on Username () or Role
Similar to: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18688456-hide-pages-based-on-role
And:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16059178-page-tab-level-security
RE: Hide columns or pages based on Username () or Role
While RLS is very useful, we need a way to obscure certain data points and possibly whole tabs for certain roles.
As an example, take expenses. All of the management team would need to see the numbers and impact but there is sensitive descriptive data in an associated column that should only be seen by the board.
Currently the only workaround we have is to have two separate reports where the Board only column is hidden for the management version and visible for the board version.
By the same token board members may have an entire tab that only they should see.
Allowing other types of security would save significant time by having one complete report that could be tailored to multiple groups.