Skip to main content

Power BI

Needs Votes

Column Level Security for reports

Vote (2720) 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).

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

fd3109dc 8675-41cf-a32a-6897b4d711cc 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

4c3ea83d 143c-42cb-bfb0-b55f185b85d0 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

48ed2958 1109-4b16-9fe1-b3e57de6e58e 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

80f25025 3649-41d9-bf6c-e0431acae925 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!

Tarun Singla's profile image Profile Picture

69aa9488 5740-4224-bd38-fa61b99b4837 on 06 Jul 2020 00:11:29

RE: Column Level Security for reports

Nedded

Tarun Singla's profile image Profile Picture

2747992b cbdc-4573-b086-4af84387ef87 on 06 Jul 2020 00:10:25

RE: Column Level Security for reports

Yes, this is needed. I'm going to look at some tips / workaround out there to achieve it, but it is needed. To prevent multiple datasets / queries.

Tarun Singla's profile image Profile Picture

037c64f1 f1e8-4b9d-9280-6d6e1b1b0d53 on 06 Jul 2020 00:09:54

RE: Column Level Security for reports

this is really more important to restrict the data at column level especially in Marketing region.

Request Microsoft to implement this ASAP.

Tarun Singla's profile image Profile Picture

cf5840d0 4748-4611-90cd-87d4a4f36efb on 06 Jul 2020 00:09:23

RE: Column Level Security for reports

We need Column level security to avoid multiple datasets for each department in an organization, and also to protect the sensitive data from unauthorized users.

Tarun Singla's profile image Profile Picture

0f9a8664 d01a-47ac-980c-8afafe2b3d69 on 06 Jul 2020 00:08:37

RE: Column Level Security for reports

This would be required to have a single PowerBi data set that covers the organisation

Tarun Singla's profile image Profile Picture

e528b07e 175b-4bdc-9e2c-ba331e408a44 on 06 Jul 2020 00:08:09

RE: Column Level Security for reports

This is essential for the type of data and the variety of users we work with.