Datamart Row-Level Security

[JR-DCPS]

So I'm excited to try out the new datamarts, but is there or will there be a way to do RLS dynamically like in the desktop version? I can't use the current version of the RLS offerings because 1) there's a fair amount of change between security groups and 2) it would mean maintaining over 100 different security groups per datamart which is extremely unfeasable.

Any further info or assistance on a workaround would be extremely helpful.

[cedar]

Is there any place where we could rate this option to be developed ?

[JR-DCPS]

https://ideas.powerbi.com/ideas/idea/?ideaid=efab463e-1444-ed11-97b2-501ac5248c93

It doesn't have many votes, but it seems like I'm not the only one who needs the dynamic option for datamarts.

[daniel_jaramill]

Hello, any luck doing dynamic RLS on datamart PBI ?

[v-zhangti]

Hi, @JR-DCPS 

Based on your description, you could need dynamic RLS with a hierarchy.

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

https://community.powerbi.com/t5/Desktop/Dynamic-Row-level-security/m-p/1276566#M559193 

https://www.kasperonbi.com/power-bi-desktop-dynamic-security-cheat-sheet/ 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JR-DCPS]

Hi @v-zhangti ,

As I mentioned, I am currently using the solutions you provided and they've been working well for the past year. The issue is that the RLS is structured differently in the new Datamart models. For a dataset, I'm restricted to "Column equals value" type statements and can't put a DAX function in as shown in the screenshot below.

I did try to just paste the DAX expression in, but that doesn't work. So as per my original question, is there a timeline to put PBI Desktop-style RLS in place for Datamarts or is there something I'm missing?

[Anonymous]

This is also crucial to our use cases!

Any update on when we'll be able to use DAX expressions in Datamart security groups like we can in PBI Desktop?

[J_Zayak]

I am also needing guidance on if it is possible to implement dynamic RLS in a datamart as detailed in Configure row-level security with the dynamic method - Learn | Microsoft Docs.