Forum Discussion
Rnaval
Post Partisan
1 month agoSwitching data source from excel to csv - the keys didn't match any rows in the table
I'm changing the data source from excel to csv and I get this error message when I apply changes - the keys didn't match any rows in the table, any ideas on how to diagnose further?
- 1 month ago
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
danextian
Super User
1 month agoPlease post both queries so it would be easier for us to find out the possible cause.