Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi, the official documentation says that if I connect to a table that has RLS in the SQL Analytics Endpoint, Direct Lake will fall back to DirectQuery: Develop Direct Lake semantic models - Microsoft Fabric | Microsoft Learn
Does the same thing apply if I don't define the RLS on the lakehouse/warehouse but directly in Power BI?
Solved! Go to Solution.
I've found the answer: Manage Direct Lake semantic models - Microsoft Fabric | Microsoft Learn
[...] If different users must be restricted to access only subsets of data, if viable, enforce RLS at the semantic model layer only. That way, users will benefit from high performance in-memory queries.
So the answer is no: DirectLake does not fall back to DirectQuery
I've found the answer: Manage Direct Lake semantic models - Microsoft Fabric | Microsoft Learn
[...] If different users must be restricted to access only subsets of data, if viable, enforce RLS at the semantic model layer only. That way, users will benefit from high performance in-memory queries.
So the answer is no: DirectLake does not fall back to DirectQuery