Forum Discussion
Sort By value set in Fabric Sematic Model is not being reflected in Power BI Desktop
I have a value in my date table to contains the month name follow by the year. For each distinct value I created a custom sort order field. I made the change in the Fabric model, but the report in desktop is not refelcting the change. Other changes I make such as adding messures, changing data formats in the Fabric semantic model do get reflected properly when I refresh the model on desktop.
Here are a couple of images of what I am seeing. Does anyone have a way to work around this?
Fabric:
Power BI Desktop:
Hi DavidMc ,
Thank you djurecic for the helpful response!
As connected live to the semantic model, some model level changes like Sort by column may not reflect in Power BI Desktop. Live connections allow you to query the model but do not fully refresh or apply metadata changes such as column sorting. Please ensure the changes are saved and processed in the Fabric model, and try refreshing visuals or reconnecting to the semantic model from Get Data -> Power BI semantic models in Desktop.
This is an expected limitation with live connections, as documented here:Connect to semantic models in Power BI - Power BI | Microsoft Learn When using a live connection, you can't create calculated columns or change sort by column options in Desktop.
Hope this helps.
Thank you.
Regards,
Pallavi.
3 Replies
Hi DavidMc ,
Thank you djurecic for the helpful response!
As connected live to the semantic model, some model level changes like Sort by column may not reflect in Power BI Desktop. Live connections allow you to query the model but do not fully refresh or apply metadata changes such as column sorting. Please ensure the changes are saved and processed in the Fabric model, and try refreshing visuals or reconnecting to the semantic model from Get Data -> Power BI semantic models in Desktop.
This is an expected limitation with live connections, as documented here:Connect to semantic models in Power BI - Power BI | Microsoft Learn When using a live connection, you can't create calculated columns or change sort by column options in Desktop.
Hope this helps.
Thank you.
Regards,
Pallavi.
