Append or merging tables removes security from DataVerse

[EspenHelliesen]

Hi, so we have some issues regarding Power BI and data from Dataverse. We have data in two different tables that comes from Dataverse. We use Direct Query in PBI, and when connecting directly to the table the security looks fine. (users have access to the data they are supposed to). But when we combine the two tables using either Dax og Append, every user get access to all the data. It seems that these functions just cancel all security that is implementetd i Dataverse.

Anyone experienced the same or have any solutions to this issue?

Regards

Espen

[amitchandak]

@EspenHelliesen , This will a table in import mode, I doubt you have force RLS in Power BI

[EspenHelliesen]

@amitchandak , hmm...  what you say can be true. The funny thing is though that if I append to an existing table, the RLS works, but the procedure does something funny with the data. For example all columns with numbers dont work, and for some reason relations to other tables wont work. If i Append to a new table the RLS disappears