Direct Lakes in Microsoft Fabric · Learn Microsoft Fabric

Jul 17 • General

Direct Lakes in Microsoft Fabric

Power BI supports two flavors of Direct Lake connectivity:

𝐃𝐢𝐫𝐞𝐜𝐭 𝐋𝐚𝐤𝐞 𝐨𝐧 𝐎𝐧𝐞𝐋𝐚𝐤𝐞

🔹No DirectQuery, optimized for delta tables

🔹Supports multi-source (Lakehouse + Warehouse)

🔹Built inside Power BI Desktop (web editing coming soon)

🔹Permissions managed at the source-level

𝐃𝐢𝐫𝐞𝐜𝐭 𝐋𝐚𝐤𝐞 𝐨𝐧 𝐒𝐐𝐋

🔹Uses DirectQuery for views/SQL endpoint

🔹Single-source only

🔹Created via web portal, editable in Desktop or web

🔹Permissions managed via SQL endpoint

awesome demo on MS Fabric Youtube Channel :

I aslo recommend this article for a deeper dive:

3 comments

skool.com/microsoft-fabric

Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.

Leaderboard (30-day)

+35

+23

+19

+15

+12