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

[Anonymous]

Hi,

I face this error when I try to apply my power query : "OLE DB or ODBC error:  Expression.Error: The key didn't match any rows in the table." It appears on all queries.

There is no error or warning anywhere.

I use only csv or xlsx so no database connection.

All the dates used are declared as date not datetime.

Any help please ?

Thanks

[Anonymous · Accepted solution]

I don't know why but the issue was due to my xlsx, I have converted it as csv and it works then. It's not a real solution but a good workaround