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

Rushil Dajee on 05 Jul 2020 23:21:11

RE: Column Level Security for reports

A must have to ensure more flexible control over the data represented.

Tarun Singla's profile image Profile Picture

Falcone on 05 Jul 2020 23:21:11

RE: Column Level Security for reports

Please add - this will be a great addition to the RLS.

Tarun Singla's profile image Profile Picture

mathew on 05 Jul 2020 23:20:34

RE: Column Level Security for reports

This is very much needed. Otherwise we need copies with the columns formally removed, this increases time taken, and possible errors.

Please resolve ASAP

Tarun Singla's profile image Profile Picture

bullius on 05 Jul 2020 23:18:39

RE: Column Level Security for reports

Just went through hiding fields I didn't want to be seen using "See records". Not ideal. This should be a standard feature.

Tarun Singla's profile image Profile Picture

Power BI User on 05 Jul 2020 23:18:30

RE: Column Level Security for reports

this feature is essential for handling multiple users and hierachies

Tarun Singla's profile image Profile Picture

Paul Innes on 05 Jul 2020 23:18:17

RE: Column Level Security for reports

Also important to me. Some fields need to be hidden from certain roles/users. Any work around anybody?

Tarun Singla's profile image Profile Picture

James Thompson on 05 Jul 2020 23:17:23

RE: Column Level Security for reports

Cannot stress how important this feature is.

Tarun Singla's profile image Profile Picture

Power BI User on 05 Jul 2020 23:14:54

RE: Column Level Security for reports

In SSRS it is possible using Column Visibility functinality which allows to hide or show column dynamically based on parameter value. Similar behavior should beavailable in BI. For Cost related report it is sometimes mandatory to hide column for specific people.

Tarun Singla's profile image Profile Picture

Nir Robinson on 05 Jul 2020 23:12:06

RE: Column Level Security for reports

please add it .
today we need to duplicate many reports :-(

Tarun Singla's profile image Profile Picture

Mudasar Ansari on 05 Jul 2020 23:10:48

RE: Column Level Security for reports

This is a common business requirement. Please provide