DirectQuery RLS

[rimah]

Could someone please tell me How I can configure RLS on a dataset using DirectQuery and import, in power BI?

I have a table that imported and I added a role on it "UserprincipalName()" but when I tried "View as Role" only the table that I added a role on it is filtred but the others are not. 

I can not see this when I add a relation between the imported table and the DQuery Table

[amitchandak]

@rimah , Usually this is what we do, we take a global dimension and filter that using RLS.

The global dimension is one which joins with all fact example like region, item, customer etc

[rimah]

Sorry, but how can we add Rls on a DirectQuery table in power BI is it even possible.

I am adding Rls on an imported table that is a global dimension but it's only filtering itself.

[v-chenwuz-msft]

Hi @rimah ,

You need turn off the apply security filter in both directions when you use RLS.

Result:

If you need more help, please share some example data.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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

[rimah]

Thank you for your answer, unfortunately, I can not see the data, I don't have access,

but my question is about the table "TABEL" is DirectQuery so how can you see it here 

in my report when I can not see all the tables that are in DirectQuery mode in the "Role" second when I add a role like you did my data is not filtred I see all data (I am using Dynamic RLS  USERPINCIPALNAME).

[v-chenwuz-msft]

Hi @rimah ,

Can you share your pbix file without sensitive data or some screenshot of your filter dax in rls role.

Best Regards

Community Support Team _ chenwu zhu

[rimah]

As you can see I only can see the imported tables and the filter that I added does not work on the other table(DirectQuey)