Forum Discussion
Super Userhow 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 report:
and now all of those i want to move into OneLake semantic remote model without using any Semantic Labs or additional scripts.
How?
Best,
Jacek
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.
3 Replies
- lbendlin
from import mode report into OneLake semantic modelNot sure what you mean by that. Can you elaborate?
- jaryszek
Need to create Measure Table in One Lake Model. In usual import mode I have built table using ower query editor, called it Measure Table and added folders and measures there.
Now I want to move this entire table into One Lake Model but issue is that i can not add table in One Lake Layer. Only dax table which is calculated one.
I have no idea how to move the same shape of Measure table into OneLake Model
v-ssriganeshCommunity Support
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.
