About the effect of sorting powerquery

[Anonymous]

I'm a beginner.

Let me ask you about the impact of the sorting function of powerquery.

You can sort the data as you want with powerquery, but you can also sort the data with PowerBI desktop.

When sorting with powebi desktop, there is no point in sorting with powerquery, but is there any part that only powerquery sorting affects?

For example, does the data order of the output file sometimes depend on the sort of powerquery?

I would be grateful if anyone could teach me. Thank you.

[Anonymous]

Hi @Anonymous ,

The sorting order in Power Query only controls the sort order in Data Model of Power BI Desktop.

It doesnot control the sorting of any visual.

Appreciate your kudos!! Please mark my post as solution if this helps.

[Anonymous]

Thank you for answering!

Then, is it correct to recognize that the data order of the output file reflects the setting order of Powerbi desktop?

The file currently being created is sorted by both powerquery and powerbi desktop, and I'm thinking of deleting the sort of powerquery if the processing is wasted.

[Anonymous · Accepted solution]

@Anonymous ,

Sort order of the output file depends on the sort of the visual.

The sort order of the visual can be adjusted like below, clicking on the ellipses and then choose the sort type accordingly.

Appreciate your kudos !! Mark this post as solution if this helps.