cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
shabbirmala
Advisor

Object Level Security workaround

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Object Level Security workaround

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Object Level Security workaround

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.