Forum Discussion

shabbirmala's avatar
shabbirmala
Frequent Visitor
7 years ago
Solved

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-server-2017

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15578172-column-level-security-for-reports?page=1&per_page=20

 

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

 

Thanks,

Shabbir

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    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