Security of columns

[sjensen]

There have been simular feeds on this but nothing I could see that fully answers this question. I want to allows some users to view a column but others to not view it. So hiding is not an option because then no one could see it. I want some managers to be able to see the information and others not to see certain information. I know this is possible through rows using the manage roles option under modeling but I need columns not rows with the security. Anyway to do this? 

[GilbertQ]

Hi there,

Currently this is only available for SSAS Tabular 2017 or in Azure Analysis Services, hopefully it will be coming to Power BI.

https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/object-level-security?view=sql...

If this is a requirement possibly look at leveraging Azure Analysis Services.

[sjensen]

Thank you very much for the response! I will look into those options

[henriquesilveir]

Hello @sjensen have a post about your question that are marked as solution, take a look: https://community.powerbi.com/t5/Desktop/Restrict-Column-Access-with-RLS-Almost-there-but-some-annoy...

don't forget to mark as solution if you got it, okay?

Let me know if it works,

Best Regards,

[sjensen]

Hi Henriquesilveir, 

It looks like that is only to hide rows. Is there a way to hide full columns?