Column level security in Power BI

[Anonymous]

Hi Team,

I have two sets of users, assuming User Group A and User Group B.

Requiremnt as below,

1. There are 5 columns in a Table Visual in a page of a PBI report.

2. Col1...Col3 should be visible for Both the Groups A&B.

3. Col4 should be visible only for Group A.

4. Col5 should be visible only for Group B.

Please help me in accomplishing the above requirement. Please let me know if further information required.

Thanks in advance.

Regards,

@Anonymous 

[otravers]

This is an old thread, CLS is available in Power BI (Premium) since 2021:

- https://powerbi.microsoft.com/en-us/blog/object-level-security-ols-now-available-for-public-preview-...

- https://www.oliviertravers.com/row-level-security-rls-business-intelligence/#15_Data_Masking_Object_...

[Anonymous]

You can check out this video. This guy has achieved CLS in Power BI with an easy trick

https://youtu.be/OhJ9HPoH6VQ

[DebbieE]

Just found this on the ideas board

https://ideas.powerbi.com/ideas/idea/?ideaid=3c6dd5d0-a2f9-44ae-a213-3a8c0d14dfd0

Ive popped a vote in for column level security, the more votes the merrier

[collinq]

Hi @Anonymous ,

In Power BI there is not a COLUMN security capability.  You can use the Row Level Security and you can configure your own Table level security as part of that.  But, you can not specifically do security on a specific column WITHIN a dataset query/table.  My suggestion would be (at this is NOT necessarily efficient use of resources, but it solves this specific problem) to duplicate the table itself and have the columns separated there.  This probably means two visuals as well.  You can do security at that level with RLS and/or with using the sharing on the reports that you hide/unhide.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!