I have project that will use Microsoft Fabric to implement Medallion architecture.
Bronze: Fabric Lakehouse
Silver: Fabric Lakehouse
Gold: Use Data Warehouse
There are requirements to do RLS/OLS/Masking to the table while also need RLS to working on report aswell . The problem is when create semantic model from the table that already applied security it will be fall back from Direct Lake to Direct Query.
I still need Direct Lake Mode working while have RLS/OLS/Masking when user query table through SQL
Can anyone suggest me what should I do with this scenario?