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, maybe it's not a proper woraround, but ... In my case helped to do all calculation on the tabs coppied from those upload to M BI. So as a rule I upload all the data I need for the project, than merged, coppied etc. to new tabels and later functionalities are build on those new. Original data are keep in the project without any manipulation, one I do and it's works is lookupvalue from the original tabels. I can assume that if we taking the data from original tabels it's fine for them, when we are try to add some data it's causing the problems with later updates.
Hope it's help you and do not affect efficiency of yours projects