Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
jaryszek
Power Participant
Power Participant

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 report:

jaryszek_0-1757084654487.png

 

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


1 ACCEPTED SOLUTION
v-ssriganesh
Community Support
Community 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.

View solution in original post

3 REPLIES 3
v-ssriganesh
Community Support
Community 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.

lbendlin
Super User
Super User

from import mode report into OneLake semantic model

Not sure what you mean by that. Can you elaborate?

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.