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

Hi jaryszek,
Thank you for posting your query in the Microsoft Fabric Community Forum.

Adding a DirectQuery table via Tabular Editor may appear to work at the metadata level, Microsoft only supports composite models (Direct Lake + DirectQuery) when the semantic model is created and owned as a composite using supported tools, not by extending an already published remote Direct Lake on OneLake semantic model.

The best approach is to Create and own the semantic model in Fabric, including Direct Lake (OneLake) tables and Warehouse tables, letting Fabric manage the storage modes (Or) create a new local semantic model as a composite model that includes Direct Lake and DirectQuery tables.

Thanks, Jaywant-Thorat for sharing valuable insights.

Best regards,
Ganesh Singamshetty.

jaryszek's avatar
jaryszek
Super User
6 months ago

Hello,

 

thank you. 

Please explain what this means: "when the semantic model is created and owned as a composite using supported tools"

Tabular Editor 3 has option to import tables from a warehouse. 

Best,
Jacek

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

    Hello jaryszek,
    I mean that the semantic model is initially built and authored using Microsoft supported modeling experiences, where composite models are explicitly supported and documented.

    According to the documentation:

    • jaryszek's avatar
      jaryszek
      Super User
      6 months ago

      Ok so we misunderstood. 

      My question is: if warehouse table using Fabric environment can be used together with OneLake semantic model? 

      Assume you have 3 tables on DirectLake over OneLake. This is DirectLake mode.
      But now I want to add warehouse table, so I am goinf to fabric, clicking import table, choosing Fabric Warehouse...It will work? 

      Or we will have semantic model version issues or something like that?

      Best,
      Jacek

      • 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).