Forum Discussion
Ozz_Kozz
Jun 14, 2021Copper Contributor
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. ...
Yea_So
Jun 21, 2021Bronze Contributor
The column data types on both table must be the same.
What kind of join did you select in your merge query?
cheers
- SergeiBaklanJun 21, 2021MVP
- Yea_SoJun 21, 2021Bronze ContributorSergeiBaklan,
So which is it that's creating the error message since you already re-created the error- SergeiBaklanJun 21, 2021MVP
That's in my very first answer above