Object Level Security workaround

[shabbirmala]

All - Is there any workaround for implementing Object level security using DAX along with RLS?

I have read on MS docs and PowerBI Ideas that its not supported and see people are requesting this feature. 

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

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15578172-column-level-security-fo...

But till that gets released - has anyone tried walkaround (or any recommendation)?

Thanks,

Shabbir

[v-yulgu-msft · Accepted solution]

Hi @shabbirmala,

In Power BI, we can only limit data access on row level. Object level security is not supported.

As a workaround, you could unpivot your source table to convert column headers into rows. Then you can control users' access to specific columns via applying RLS indirectly. And you can put the converted column into Column group within Matrix visual to make it appear like a "column".

Reference: Unpivoting Sensitive Columns in Power BI to Apply Row-Level Security

Best regards,

Yuliana Gu