Forum Discussion
nleuck
Post Patron
Post PatronPower BI sorting issue with data connection to Analysis Services
Hello All, There seems to be an issue with how Power BI sorts numeric month values from a Live Connection to Analysis Services. If I select Month Number from my Date table (in our database this ...
nleuckPost Patron
Post PatronYou can't use Sort by Column when you are using a live connection to Analysis Services. All features in the Modeling tab are greyed out.
LivioLanzo
Solution Sage
Solution SageI know, I meant to check on SSAS side
- nleuck
It's sorted in chronological order.
nleuck,
In my scenario, Month number shows in an expected order in Power BI Desktop. Please make sure that your monthnumber field is sorted correctly on SSAS side. And you can post question about SSAS sort in SSAS forum to get better support.
Regards,
Lydia