Forum Discussion

Omega's avatar
Omega
Impactful Individual
6 years ago

Sort columns in matrix when connected to SSAS (Live Connection)

Hi,    I am connected to SSAS (Live Connection) and created a matrix that has date as column. I want to show the latest date from left to right. I've read multiple threads but seems there is no sol...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Omega 

 

Based on my research, It is unsupported to achieve your requirement. When connecting live, no data from the tabular model is imported into Power BI Desktop. Each time you interact with a visualization, Power BI Desktop queries the tabular model and calculates the results you see. You’re always looking at the latest data that is available in the tabular model. You can create report level measures in the Power BI Desktop, but all other query and modeling features are disabled when exploring live data.

 

For further information, you may refer to the official document .

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-alq-msft 

 

This option is not available for any other sources. 

For simple sorting, i don't think creating index columns is right approch.

I think microsoft team need to add this simple feature for matrix.

 

Please vote for similar ideas. I already  mentioned link.

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.