Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
But till that gets released - has anyone tried walkaround (or any recommendation)?
Thanks,
Shabbir
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.