Forum Discussion
Data refresh error: OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D.
I am trying to refresh a table (with less than 50 records and 200 columns). The source is a text file on my desktop and I am pretty sure nothing has changed except a few additional records in the ne...
Hi all,
I found this video that might be helpful. I could solve the issue thanks to it. You just need to check if the data type of the columns is correct. They should also match the data type you have in your DataBase.
OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D | Power bi Refresh Error - YouTube
Thank you so much - this was driving me crazy! It just suddenly stopped working but this did the trick 😊