Forum Discussion

DavidMc's avatar
DavidMc
Frequent Visitor
1 year ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.