Sort By updated in service but not in desktop

[jbxfd]

I have a custom semantic model from lakehouse tables. I updated the sort by of the 'accounting_period_label' column in the pbi service. I have refreshed and gone back into the model to confirm the change held, and it did.

The problem is when I go to desktop and live connect to this model the sort by column for 'accounting_period_label' is still the default.

I have tried refreshing the model in the service and refreshing the connection in the desktop app.

In the service:

In the desktop app:

Am I missing something? Any other changes I make to the model in the service, I can immediately see the changes in the desktop app.

Thanks

[v-lgarikapat]

Hi @jbxfd ,

Thanks for reaching out to the Microsoft fabric community forum.

@Greg_Deckler ,

Thanks for your prompt response

@jbxfd Based on the details you shared, here are a few workarounds you can try to help resolve the issue.

1.Manually Reapply the Sort in Desktop Report Visuals: Even though you're live connected, Desktop doesn’t always inherit metadata like Sort by Column. Try explicitly setting the sort in the visual's fields pane.

2. Use a Calculated Column with Sort Order: If accounting_period_label is backed by a numerical or sortable key (like accounting_period_code), ensure that column is part of the model and explicitly reference it in Desktop for sorting especially if you're customizing visuals there.

3.Refresh Metadata via Live Connection: Sometimes Power BI Desktop caches schema metadata. Try:

• Removing and readding the live connection (under Transform Data > Data Source Settings).
• Or going to Model view, then Refresh All to pull the latest metadata.

4.  Deploy the Model from Desktop: If you want full control and consistency, you could make the change in a local Power BI Desktop file (PBIX), then publish it to the service. This ensures the metadata behaves predictably across both environments

For referances :

Sort one column by another column in Power BI - Power BI | Microsoft Learn

Solved: Sort Columns using Live Connection - Microsoft Fabric Community

If you're still facing the same issue,
I suggest raising a support ticket so the support team can assist you in resolving the problem.
Please refer to the link below for instructions on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this post helped resolve your issue, please consider marking it as the Accepted Solution.
This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana

[v-lgarikapat]

Hi @jbxfd ,

 If your issue has been resolved, please consider marking the most helpful reply as the accepted solution. This helps other community members who may encounter the same issue to find answers more efficiently.

If you're still facing challenges, feel free to let us know we’ll be glad to assist you further.

Looking forward to your response.

Best regards,
LakshmiNarayana.

[v-lgarikapat]

Hi @jbxfd ,

If your question has been answered, kindly mark the appropriate response as the Accepted Solution. This small step goes a long way in helping others with similar issues.

We appreciate your collaboration and support!

Best regards,
LakshmiNarayana

[v-lgarikapat]

Hi @jbxfd ,

As we haven't heard back from you, we are closing this thread. If you are still experiencing the issue, please feel free to create a new thread we’ll be happy to assist you further.

Thank you for your patience and support.

If you found our response helpful, please mark it as Accepted Solution and consider giving a Kudos, so others with similar queries can find it easily.

Best Regards,

Lakshmi Narayana

[Greg_Deckler]

@jbxfd Sounds about right. Probably need to address this with Microsoft support.

[jbxfd]

@Greg_Deckler 
The selected sort by is actually working. I suppose I should have checked that sooner. So the issue is the desktop is not reflecting the actual sort by from the live connected model in the selection box but it is using it.

[Greg_Deckler]

@jbxfd Sounds like a bug to me.