The key didn’t match any rows in the table - Error

[apanta]

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!

[ppm1 · Accepted solution]

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

[lbendlin · Accepted solution]

Chris Webb's BI Blog: Understanding The “The key didn’t match any rows in the table” Error In Power ...

[ppm1 · Accepted solution]

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