In Power Query, how to sort non-english strings?

Hakan Özhan 5 Reputation points
2024-06-19T16:24:49.8866667+00:00

I can sort according to the Turkish alphabet in Excel.

When I sort the same table in Power Query, it does not sort in Turkish.

Excel and power query window region setting is Turkish.

User's image

Görüntü

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,545 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 25,551 Reputation points Microsoft Vendor
    2024-06-20T08:00:12.3633333+00:00

    Hi,

    You should sort in Power Query editor but not the source table.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.