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

[Knegge]

Hi,
i have been trying for a while now, maybe someone can help me.
I have a published Semantic Modell (without RLS) that I connect to. I have an additional table that I am adding as an imported table from DBX. The imported table serves as a RLS Table with emails and Profit Center information. I connect this table to the Business Hierarchy Table of the Semantic model and implemented an RLS Role onto that imported table.
When trying view as the RLS on the importet table works but it does not migrate through to the connected Semantic Model from the Service. 
When I first published I got an Extension error for the login info, although DBX is connected through a gateway and the Semantic model I have access to.
After a while the error disappeard and I could add the Mails to the RLS Role.
When someone with access to the report opened it he could not see any info in the RLS Table (he has no rights there, so as expected) but all connected tables remained unchanged by the RLS and he could see all. 
Can anyone please help.

BR Knegge
Here is a screenshot of the Relationship (connection is 1:1)



I have some other thoughts and bits of info that might be the reasons but I cannot validate and dont know:
When connecting to a Semantic Model it is a "Live" Connection but it can be switched when adding a local table and than it is Direct Query, but is it really? 
Live Connections cannot have a RLS put ontop but Direct Query should be able to?

[MFelix]

Hi @Knegge ,

I'm looking into your relationships and you have a one to one from the RLS to a Business hierarchy is this table a dimension table or a fact table? How does the Business hierarchy relates to the rest of the model?

Also can you share what is the formula that you are using in the RLS and in what field you are applying the DAX for the RLS.

[Knegge]

Hi Miguel,
The Business Hierarchy Table is the shared Dimension Table for some fact tables.

In a seperate model that has all tables as import mode from DBX this filtering through the 1:1 RLS to BH works without fail.

For this specific case it is nessecary that I apply the RLS thorugh a new imported table from DBX  to a published Semantic Model that doesnt have RLS on it yet.