Error 401: Multi-RLS with Direct Query

[marinasolers]

Hello, 

I have a data model which has his own RLS, let's say model1. 

I connect to this model and add some local data sources, which would be my composite model2.

When I try to add new RSL to my model2, I get error when trying as a role (Error 401). This Row Security level is not applied to any of the tables from model 1, but for some tables from model 2.

Does anyone know if it's possible to have RLS in that way? In that case, how could I solve it?

Thanks in advance, 

[v-zhangti]

Hi, @marinasolers 

Please refer to the following links in the hopes of helping you.

Solved: RLS on composite model mode(Import from serviceno... - Microsoft Power BI Community

Solved: RLS in composite mode - Microsoft Power BI Community

Solved: 401 error - Microsoft Power BI Community

Known Issue - Multi-role row-level security for composite models may fail - Power BI | Microsoft Lea...

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.