OLE DB or ODBC error - Sharepoint (Excel)

[ronaldbalza2023]

Hi everyone, could someone help me out on this please. I imported sharepoint (excel) as data source. It is showing an error: 

OLE DB or ODBC error: [Expression.Error] The key didn't match any rows in the table..

[v-xiaotang]

Hi @ronaldbalza2023 

This is a typical case when you connect to an Excel file and then your Query attemps to access a Sheet that does not exist in the Spreadsheet.

Best Regards,

Community Support Team _Tang

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

[FarhanAhmed · Accepted solution]

See if sheet for Excel file referenced still exists in file.