Datamart - Many-to-Many

[NetrushJacob]

Attempting to implement a datamart that allows for an RLS setup where a fact table has an account Id column and a user authorizations table has the user Id with the allowed account Ids for that user.

Power BI Desktop allows this to be created as a many-to-many relationship, but Datamart does not seem to allow that setup.

Am I missing something? How can I configure a Datamart with this level of RLS?

Example:

• User 1 has access to Account 1, Account 2, Account 3
• User 2 has access to Account 1, Account 2
• Facts 1-1000 belong to Account 1
• Facts 1001-2000 belong to Account 2
• Facts 2001-3000 belong to Account 3 
• Role AccountUser filters UserId to username()

User Id	Account Id
User 1	Account 1
User 1	Account 2
User 1	Account 3
User 2	Account 1
User 2	Account 2

[v-luwang-msft · Accepted solution]

Hi @NetrushJacob ，

The data mart is currently in preview and is still being refined, so you can try it out by following the steps in the article below (although I don't see any restrictions on rls in the official article)：

https://docs.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-access-control 

And here is a similar issue about RLS for many to many relationship model in Power BI. Please refer to the link below and check if it helps or not.
https://community.powerbi.com/t5/Desktop/RLS-not-working-totally/td-p/68342

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien