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

[jaryszek]

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

[v-ssriganesh · Accepted solution]

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.

[lbendlin]

from import mode report into OneLake semantic model

Not 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