DirectLake over OneLake with combination with DirectQuery tables

Hi jaryszek 

Short Answer = No, not in the way you’re describing.

Let me elaborate What works vs what doesn’t:
You cannot:

• Take an existing DirectLake semantic model (remote)
• And extend it with DirectQuery tables
• To create a composite model

A remote DirectLake model is read-only for modeling.

You can do this instead:

Option 1 : Fabric way

• Build all tables inside Fabric
  • DirectLake tables (from OneLake)
  • Warehouse tables (SQL)
• Let Fabric automatically handle:
  • DirectLake
  • DirectQuery
• One semantic model → works fine

Option 2 : Classic Composite

• Create a new local semantic model
• Add:
  • DirectLake tables
  • DirectQuery tables (Warehouse / SQL)
• This works only if the model is local, not remote

Key rule to remember:

• You cannot extend a remote DirectLake semantic model.
• Composite models work only when you own the model.

Recommendation: If you’re already in Fabric

• Create everything in Fabric (Warehouse/Lakehouse)
• Let Fabric manage DirectLake + DirectQuery natively

=================================================================
Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Jaywant Thorat | MCT | Data Analytics Coach | Super User
LinkedIn: https://www.linkedin.com/in/jaywantthorat/
Join #MissionPowerBIBharat: https://tinyurl.com/JoinMissionPowerBIBharat
#MissionPowerBIBharat
LIVE with Jaywant Thorat