Hiding an entire column for specified users by RLS

[Analyst001]

Hello Friends, I need help on creating Row Level Security to hide the entire column. I tried creating roles in RLS but it is only filtering values.

Is there anything like column-level security in power BI?

Thank you in advance.

[Fowmy · Accepted solution]

@Analyst001 

You can achieve this using Object Level Security (OLS). Please refer to the following article on how to apply.

https://www.fourmoo.com/2021/03/02/configure-ols-in-power-bi-using-tabular-editor-to-limit-access-to...

[mmace1 · Accepted solution]

Object-Level-Security is now natively avaiable in Power BI 

https://powerbi.microsoft.com/en-us/blog/object-level-security-ols-is-now-generally-available-in-pow...

I haven't actually had a reason to use it yet, but it seems like exactly what you need. 

[mmace1]

Like you've noticed, Row Level Security only applies to Rows, not Columns. 

Object-Level security as linked. 

Or, you could copy the report, with that column not displayed- and give the users that shouldn't be able to see that colum, only access to that other report.   

[Fowmy · Accepted solution]

@Analyst001 

You can achieve this using Object Level Security (OLS). Please refer to the following article on how to apply.

https://www.fourmoo.com/2021/03/02/configure-ols-in-power-bi-using-tabular-editor-to-limit-access-to...

[Analyst001]

Thank you for the quick response Fowmy, but External tool is not enabled on my Desktp. Please guide me on this thank you.

[Fowmy · Accepted solution]

@Analyst001 

Please download the Tabular Editor 2 from the following link: https://github.com/otykier/TabularEditor/releases/tag/2.16.0

[mmace1 · Accepted solution]

Object-Level-Security is now natively avaiable in Power BI 

https://powerbi.microsoft.com/en-us/blog/object-level-security-ols-is-now-generally-available-in-pow...

I haven't actually had a reason to use it yet, but it seems like exactly what you need.