Can't find error when loading multiple files from folder

[thomas9921]

Hello, 

I have a Power BI report that pulls data from 4 different sharepoint folders, each have many files in them. When I refresh the data it runs into the error , OLE DB or ODBC error: [Expression.Error] The key didn't match any rows in the table. This stops the data refresh and prevents the queries from running. I have no idea which file is causing the error.  

Is there any way to find our which file is causing the error?  Or at least, is there a way to tell power bi to skip the files that have errors?

Thanks for your help!!!

[dax]

Hi thomas9921,

It seems that when load the data , something not match in  dataset. You need to check this in desktop->Edit Queries(Applied Step) to see which step contains error. I think this might be similar to below(it might have many files to combine, but some files' name are not the same, like below code, some items are not sheet1, so it refer ro sheet 1, it will cause error). You could check whether it is this situation(you could delete this reference item=sheet1 to see whetehr it work or not). 

By the way, if possible, could you please inform your code and sample for me? Then I will help you more correctly.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.