Forum Discussion
Power Query error 'The key didn't match any rows in the table.' when combining
Hello everyone, I'm trying to merge multiple excel files into one spreadsheet using Power Query, but I receive the following error when doing so: An error occurred in the ‘Transform File’ query. ...
I have the same error, However Im simply trying to load and save the power query from a single excel file, having only one worksheet. In fact it is from one of the Tutorials and sample files from Kevin Stratvert. All simple tutorial steps followed. single file, single works sheet "Order Data". No merge step required. However same error. Is there a bug with using the Folder Source connection? Thanks for any reply.
KR, alx
Do you use From Folder connector? Are there any other files in this folder? On which step do you have an error?