Forum Discussion
Power Query error 'The key didn't match any rows in the table.' when combining
I guess you use From Folder connector. For it both files shall have the same structure. If you select 'Client Lists' sheet for sample (first) file, sheet with the same name shall be in another file. If you combine based on structured tables, they shall have the same name in all files.
- This fixed the problem I was having! Thank you! 1 files out of 18 had a different name on the tab. I updated the name to match the other 17 and it worked!
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?
- It worked for me, thanks!
edgardcalero , glad it helped
