Forum Discussion

jaryszek's avatar
jaryszek
Super User
11 months ago
Solved

How to create a composite model with OneLake Flavour?

Hello, I am using tutorial like that: https://www.sqlbi.com/blog/marco/2025/05/13/direct-lake-vs-import-vs-direct-lakeimport-fabric-semantic-models-may-2025/  and those steps: 7 · Step‑by‑ste...
Need Help
  • v-sdhruv's avatar
    v-sdhruv
    11 months ago

    Hi jaryszek ,

    The error you are getting on the screenshot you shared previously, could be because of privacy setting configured in Power BI desktop/ service.
    You might want to check similar post related to the same issue.
    Solved: Power BI Scheduler Refresh Fail : Collection was m... - Microsoft Fabric Community
    Hope this helps!
    If this still doesnt resolve your query, kindly post the error details you are getting when you performed the refresh so that we can assist you better.

    Thank you for using Microsoft Community Forum

AmiraBedh's avatar
AmiraBedh
Super User
11 months ago

Hello !

I don't think that actually end up with a Direct Lake + Import model. From the screenshot I can see that the fact table shows DQ over AS but not Direct Lake. When the model is DQ over AS or when you probably edited a published model via XMLA), PQ isn’t available in Desktop for those tables that's you can’t transform data,

You need to build the Direct Lake stub correctly, so under get data go to OneLake data hub then Lakehouse and select only your fact table.

The fact table storage mode should be DirectLake in Model view (if it says DQ over AS, you picked the autogenerated dataset by mistake).

Then for the dimensions, under get data choose SQL Server and point to the Lakehouse SQL endpoint (or your dim source) and don't forget that the data connectivity mode should be import.

You can do your transformations in PQ

After you publish, in the Service you should find in the data source credentials in your model :

  • One for OneLake / Direct Lake (OAuth)

  • One for the SQL endpoint (Import dims)

  • jaryszek's avatar
    jaryszek
    Super User
    11 months ago

    thanks, 

    i did this like you segestted and it is not working.

    When you are going to One Lake Catalog:
    1) Choosing lakehouse
    2. Connect to OneLake:

     

     

    3) you will get yur fct table inside.

    But you can not now go once again to OneLake and chose Connect to SQL Endpoint. There is only the option to connect to OneLake tables once again. 
    This is why SQLBI created the workaround for it using import tables.

    So your answer is not working. You can not do this in one semantic model. 

    Best,
    Jacek