Sort column in table by another column when table is from Lakehouse

Hi Alaahady ,

You're absolutely right to be frustrated - this is one of those annoying gaps between Desktop and Service capabilities. The "Sort by Column" feature just isn't available in the Service for Lakehouse semantic models.

What's happening: When you connect directly from Lakehouse to create a semantic model, you lose a lot of the modeling flexibility you'd have in Desktop. The Service assumes your data is already "modeling-ready."

Your realistic options:

Option 1: Fix it in the Lakehouse Add a proper sort column to your week table in the Lakehouse itself. Something like:

• WeekSort = Year * 100 + WeekNumber
• This gives you 202401, 202402, etc. which sorts chronologically

Option 2: Use Desktop as an intermediary

• Import from Lakehouse into Desktop
• Set your sort relationships there
• Publish that semantic model to Service
• Yeah, it's an extra step but gives you full control

Option 3: Build your date logic differently Instead of "Week of Year," use actual week start/end dates that naturally sort correctly.

The gap you're hitting is real and lots of people are complaining about it. Microsoft really needs to add more modeling tools to the Service, especially for Lakehouse scenarios.

For now, Option 1 is probably your cleanest path forward if you want to stick with direct Lakehouse semantic models.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

This response was assisted by AI for translation and formatting purposes.