Sorting columns in Query Editor

[KellyLen]

Hello!

I have a problem with sorting columns. I have done two queries in two ways: I have one which has data from folder where is only one excel and second one which has data from folder where are several excels (different months' data). If I try to sort whatever column - in query which has only one excel for data, there is no problem with sorting, but in the second one it does not allow me to sort columns. It gives me a following error:

What could be the problem? 

It has to be said that every other step I would like to do is possible in both queries, the sorting is the only problem. 

Waiting for your ideas,

Kelly 

[Greg_Deckler]

Any possibility of posting the data? You might try a Table.Buffer as that often helps with sorting issues, although typically solves an entirely different problem.

[KellyLen]

Unfortunately I am not able to share data as it is very confidential. But data contains basically text columns and some date columns. I tried the Table.Buffer, but it did not made any difference, it still gave me the same error. 

[Greg_Deckler · Accepted solution]

@KellyLen, have you tried this?

https://community.powerbi.com/t5/Integrations-with-Files-and/Expression-Error-The-key-did-not-match-...

or this:

https://community.powerbi.com/t5/Desktop/powerbi-com-only-The-key-didn-t-match-any-rows-in-the-table...

[Greg_Deckler]

Are you able to reproduce the error on an obfuscated data set? Very difficult to solve if it can't be recreated.