Forum Discussion
how to create a measure table in onelake remote semantic model powerbi?
- 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.
from import mode report into OneLake semantic model
Not sure what you mean by that. Can you elaborate?