Skip to main content
Microsoft Idea

Power BI

Completed

Column Level Security for reports

Vote (2950) Share
Tarun Singla's profile image

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).

Administrator on 01 Mar 2021 17:59:24

Thanks for all your votes! I'm pleased to say this feature is shipping in the February 2021 update: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/power-bi/object-level-security

Comments (136)
Tarun Singla's profile image Profile Picture

Power BI User on 06 Jul 2020 00:02:59

RE: Column Level Security for reports

I can't believe this still hasn't been resolved when GDPR is such a huge deal. Even just the ability to mask values rather than completely remove fields (so that visuals do not break) would be hugely important to so many of your users.

Tarun Singla's profile image Profile Picture

Puneet Ghai on 06 Jul 2020 00:02:27

RE: Column Level Security for reports

Super important functionality and a big gap today. We need this NOW. You got to deliver this functionality ASAP.

Tarun Singla's profile image Profile Picture

Jon on 06 Jul 2020 00:02:26

RE: Column Level Security for reports

This would be awesome. Having to run a number of completely duplicated reports just for the sake of two columns, not at all efficient.

Tarun Singla's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:01:58

RE: Column Level Security for reports

Something we need it badly in out report, why do Power BI have half baked solutions?

Tarun Singla's profile image Profile Picture

Prashanth GanapathyRaj on 06 Jul 2020 00:01:53

RE: Column Level Security for reports

This would be a great feature to have.

Tarun Singla's profile image Profile Picture

José on 06 Jul 2020 00:01:26

RE: Column Level Security for reports

Very much needed. Please add it.

Tarun Singla's profile image Profile Picture

Power BI User on 06 Jul 2020 00:01:11

RE: Column Level Security for reports

Very much needed functionality. Also needs to be able to handle DQ sources when the column is restricted by the underlying source system if at all possible.

Tarun Singla's profile image Profile Picture

Power BI User on 05 Jul 2020 23:59:58

RE: Column Level Security for reports

The lack of this feature has a truly negative effect on our modeling abilities. We are forced to pull columns with a 1:1 cardinality into separate tables just to prevent users groups of users from viewing the data. We absolutely need the ability to prevent users from viewing data in specific columns if not part of a specific security group.

This security should also automatically extend to any calculated tables which reference said columns.

Tarun Singla's profile image Profile Picture

Balázs Katona on 05 Jul 2020 23:59:11

RE: Column Level Security for reports

As said before me, it would be a very nice feature to have in az enterprise setting!

Tarun Singla's profile image Profile Picture

Power BI User on 05 Jul 2020 23:58:55

RE: Column Level Security for reports

I can’t believe this has been over 2 years - massive naively, I would have thought this to be a relatively simple implementation. Equally I can’t believe only 700 off people have voted for this! I would have thought loads more would be after this