Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.