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

Wade on 06 Jul 2020 00:16:02

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.

Tarun Singla's profile image Profile Picture

Mohammed Adnan on 06 Jul 2020 00:14:49

RE: Column Level Security for reports

Great idea.. 1 report multiple purpose.. thanks for giving the idea..

Tarun Singla's profile image Profile Picture

Lincoln Santiago on 06 Jul 2020 00:14:24

RE: Column Level Security for reports

Extremely important and useful facture for the business area.

Tarun Singla's profile image Profile Picture

Rajnish Kumar on 06 Jul 2020 00:13:36

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

Tarun Singla's profile image Profile Picture

Sébastien DB on 06 Jul 2020 00:13:19

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.

Tarun Singla's profile image Profile Picture

Alby on 06 Jul 2020 00:13:19

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

Tarun Singla's profile image Profile Picture

Iman Eftekhari on 06 Jul 2020 00:12:26

RE: Column Level Security for reports

This is a high demand feature and a reason we go with AAS or SSAS instead of a full Power BI based solution.

Could you at least provide an ETA on this, please?

Tarun Singla's profile image Profile Picture

Ashish on 06 Jul 2020 00:12:12

RE: Column Level Security for reports

Add CLS asap. RLS alone is not helping.

Tarun Singla's profile image Profile Picture

Nick on 06 Jul 2020 00:11:52

RE: Column Level Security for reports

We are striving to have a single enterprise model in Power BI the same way we do in SSAS multidimensional. However, not every user should have access to every column/measure/table in the model.

I love Power BI, but as an enterprise semantic model, it simply doesn't have the necessary functions or tooling.

Tarun Singla's profile image Profile Picture

Todor on 06 Jul 2020 00:11:50

RE: Column Level Security for reports

Aboslutely necessary. Without this RLS has no sense for most of the cases!