Forum Discussion

jaryszek's avatar
jaryszek
Super User
6 months ago
Solved

DirectLake over OneLake with combination with DirectQuery tables

Hello Guys,   Can I create a composite model on the current existing DirectLake over the OneLake remote semantic model? I want to connect to Fabric Warehouse and make the new table a DirectQuery...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    6 months ago

    Hi jaryszek,
    As per my understanding, Compatibility level is a property of the semantic model itself, not of individual tables. Your model already runs at compatibility level 1702.

    Best regards,
    Ganesh Singamshetty.

v-ssriganesh's avatar
v-ssriganesh
Community Support
6 months ago

Hello jaryszek,
Yes, you can add a Fabric Warehouse table to your existing DirectLake semantic model (with the 3 OneLake tables) directly in the Fabric web experience. Here's how it works:

  • Go to your semantic model in Fabric > Model view > Get data  from the ribbon > Select Fabric > Warehouse > Choose your table. This automatically creating a composite model (mixing DirectLake + DirectQuery modes).
jaryszek's avatar
jaryszek
Super User
6 months ago

Thank you,

what about compatibility level? I am currently using 1702 for directLake...

It will work or there is no connection between them?

Best,
Jacek

  • v-ssriganesh's avatar
    v-ssriganesh
    Community Support
    6 months ago

    Hi jaryszek,
    As per my understanding, Compatibility level is a property of the semantic model itself, not of individual tables. Your model already runs at compatibility level 1702.

    Best regards,
    Ganesh Singamshetty.