Tarun Singla on 07 Aug 2016 15:05:48
Ability to define rules at column level, to control the data fields available to different roles (e.g. employee salary visible to the users in finance roles only, while other employee details visible to other department roles).
- Comments (130)
RE: Column Level Security for reports
I hope this gets more votes; We need this desperately or at least the ability to do composite models with AAS.
RE: Column Level Security for reports
If not outright column-level security, at least allow a function to "preserve" RLS. If I can preserve the current user as filtered by RLS, I can create a DAX calculation that can show or hide the values in a column. Not perfect, but a start... the need in our business for this, is critical.
RE: Column Level Security for reports
Wouldn't be page level security more useful?
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40467436-page-tab-level-secuirty
RE: Column Level Security for reports
This is vital in terms of efficiency of reporting with regard to maintenance and upkeep of reports.
For example let say you have columns, 1 for invoice numbers, 1 for amounts and a 3rd for line item details.
We might want certain people not to be able to see the line item detail as it may contain sensitive information but cannot ensure that only specific users can drill down to this detail.
Currently this means running multiple reports for different user groups. In most of our uses cases where data sensitivity is a factor CLS has considerably more applications than RLS, which we hardly ever use.
RE: Column Level Security for reports
If I could even access the user role via a DAX switch statement, that would be enough for what I am trying to do.
RE: Column Level Security for reports
Great idea.. 1 report multiple purpose.. thanks for giving the idea..
RE: Column Level Security for reports
Extremely important and useful facture for the business area.
RE: Column Level Security for reports
There is no option to apply column-level security. Kindly provide the option where one column is visible to one user while it is hidden for other user
RE: Column Level Security for reports
Field Level Security:
making one report for everyone, but hiding fields (columns) for some security groups. Today the workaround of building multiple reports on the same dataset is difficult and time-consuming to maintain.
RE: Column Level Security for reports
It is unbelievable how this feature is still missing in PBI: please add it asap. We are waiting for years now