Implement RLS through an Import-Mode Table onto a Published and Connected Semantic Model

Hi Knegge ,

Apologies for the late answer, and also apologies for this late explanation but my first focus was the RLS and although you have gave a good print-screen and explanation on the way you picked up the tables I did some "selected reading".

When we have a composite model the tables that are not within the same type or location when the relationship is created they have a weak realationship that is why you have a break icon near your tables on your screenshoot.

Adding to this and much more important is that the RLS is only supported for Import and Direct Query not simultaneos, and when you refer to Live connections to Analysis services, your case then this needs to be handle in the on-premises model.

https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security#considerations-and-limitations

You can also check this video with an explanation on how this limitations work and why

Overall the short answer is that for the RLS to work you need to do it in the semantic model you have and not on the Direct Query one since it's connected to analysis services.