Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
1 year ago
Solved

how to create a measure table in onelake remote semantic model powerbi?

Hello, I want to create my Measure table from import mode report into OneLake semantic model. I have already all the measures defines in subfolders within import mode table within import mode rep...
  • v-ssriganesh's avatar
    1 year ago

    Hi jaryszek,
    Thank you for reaching out to the Microsoft fabric community forum.

    In a Direct Lake semantic model, you can't directly import a Power Query-created Measure Table since it relies on physical Delta tables in OneLake. Instead, create a simple empty table like measure table with a dummy column in a Fabric warehouse using the SQL editor.

    Then, build a new Direct Lake semantic model from the warehouse, hide the dummy column, and manually add your measures with their original DAX and display folder structure in the Model view. Publish your import report first to move data tables to OneLake if needed. This keeps everything native to Fabric without scripts.

     

    Best regards,
    Ganesh Singamshetty.