Forum Discussion
Post PartisanSwitching data source from excel to csv - the keys didn't match any rows in the table
Rnaval
Error: the keys didn't match any rows in the table.
Mean that Power Query is trying to find resource, object name,column name that does not match.
Try to check the column name in power query applied steps and try to figure out which colunm name or step did not match.If you're using the Source step from Excel.Workbook(), you'll need to replace it with Csv.Document() and update the navigation accordingly.
Use View → Query Dependencies or step through each Applied Step to identify exactly where the error first appears.
If this helps, ✓ Mark as Kudos | Help Others
Super UserRnaval
Error: the keys didn't match any rows in the table.
Mean that Power Query is trying to find resource, object name,column name that does not match.
Try to check the column name in power query applied steps and try to figure out which colunm name or step did not match.
If you're using the Source step from Excel.Workbook(), you'll need to replace it with Csv.Document() and update the navigation accordingly.
Use View → Query Dependencies or step through each Applied Step to identify exactly where the error first appears.
If this helps, ✓ Mark as Kudos | Help Others