PQ-Excel: Expression Error: The key did not match any rows in the table

[lezawang]

Hi
I am following a video on how to make PowerQuery to read the latest file in a folder. I did not work for me because when I add a new file in a folder and refresh the PQ, I would get that error message. I copied all my files into another computer and It worked fine. So I am guessing it is a computer issue. I googled it and some solutions I could not follow and some fixing it using coding and some even fixing SQ!. So I did not understand them well. I would appreciate if you know the solution. Thank you very much.

 

[alansidman]

Really dont know what your issue is/was. I looked at this tutorial and had no issues

Getting data from the latest file in a folder using Power Query

One of the most common tasks of Power Query is to set up automated data refresh from multiple sources. One of them are folders, which…

wkrzywiec.medium.com

It is pretty straight forward.

 

[lezawang]

Thank you. The problem with my file. I had to edit it. Thank you again and sorry for not checking my file first.