Is it possible to use dynamic security in a Datamart?

Power Query Data Setup
1

Hi everyone,

I have spend some time creating a datamart that functions as a subset of our AAS based tabular model. The reason being, that AAS live connection does not allow for building composite model that functions when published to services.

In this endeavor it strikes me that the RLS in the Datamart is somewhat limited when compared to RLS in a dataset. I hope i am wrong but it seems that i cannot create dynamic RLS in a datamart the same way as in a dataset?

Ultimately what i want is to recreate the more advanced dynamic dax expressions with = USERNAME() and such.

Datamart RLS view:

97aSAOk6rL
97aSAOk6rL1436×848 61.1 KB

Power BI Dataset RLS view:

image
image798×254 39.4 KB

2

Hi @FrederikForum - Based on my research it seems Dynamic level RLS is currently not supported on DataMarts as there is no option to write DAX as you have already seen.

Thanks
Ankit J

1 Like
3

Hello @FrederikForum

Did the response from @ankit (thank you!) help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION.

Thank you

4

Hi @ankit

Thank you for your reply. I figured as much but i hoped i was wrong. This is the missing piece regarding using a Datamart in my work. I am crossing my fingers that this feature will be added soon!

5

Just another note. I believe that datamart (preview) isn’t in full production. You maybe doing a lot of work in datamart for nothing when it goes into full production.