OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E

In power Query i add a new column to get the week no. for another date column. everything works and i get the week numbers but as soon as I hit apply i get the following error:

OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E

Hi @hessam.vali ,

Welcome to forum.
My advice is try again - check date column type and week no
did you use :

?

Sometimes I got some different OLE DB or ODBC errors but afterword works fine.
Check again and let us know the results.

Good luck.

I was able to fix this issue. I just took a different path.
Thanks for replying my question

1 Like