Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Data transformation in Direct Query

Hello everyone, I'm encountering difficulties while attempting to sort data in Direct Query mode. Specifically, I'm looking to sort the data based on two columns: "Cohort_month_year" and "Orderdate_...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello mahenkj2 ,

I have tried sorting columns in PQ, but i get errors while doing it 

 

mahenkj2's avatar
mahenkj2
Solution Sage
3 years ago

Hi Anonymous ,

 

I can use these transformations well.

 

Connect to sql server > select table > press Ok > sort one column > edit command to add second column.

 

I am using May update of Power BI, but I don't think sorting might become a limitation. 

 

Hope it helps.