Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Column level security in Power BI

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 vis...
Data Protection
Need Help
Tips and Tricks
collinq's avatar
collinq
Super User
5 years ago

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!