Forum Discussion
Helper IThe key didn’t match any rows in the table - Error
Hi,
I am connecting one of my reports to the SharePoint folder where the files' names are saved as "Month Year" (e.g December 2023) every month. It was working fine till now but now it's throwing me the below error:
I can confirm that the sheet names are the same on all the files. Please if anyone can help me with this.
Thanks!
Check for a potential change in case or leading/trailing spaces too. Something is different in that December file. Once you find it, you can build protection into your function for that for future files (e.g., Text.Lower() ).
Pat
2 Replies
ppm1Solution Sage
Check for a potential change in case or leading/trailing spaces too. Something is different in that December file. Once you find it, you can build protection into your function for that for future files (e.g., Text.Lower() ).
Pat
