Forum Discussion

InsureBI's avatar
InsureBI
Advocate II
10 years ago

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...
Need Help
rodesteb's avatar
rodesteb
New Member
9 years ago

Hi,

 

I got the same error as trying to refresh the data and solved it by changing the data types of some of my columns from the ADVANCED EDITOR option on the Query Editor window.

 

Regards,

  • Rahul_Bhatt's avatar
    Rahul_Bhatt
    Advocate I
    9 years ago

    I don't think so this is related to data type when you referesh the table one by one you will not get this error but if you refresh all at one go you might face this also once you refresh all the table one by one and then again try to refersh all table then you will not face this error again.

     

    i think this is related to connection even its DB connected locally don't know why this happening,  files are not able to connect but when refereshed individually files its connected,

     

    i think this is a bug.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      hey all,

       

      I have the same  issues.

       

      I use a number of CSV, Excel files as a source. It will take me at least a day to reproduce my report.

       

      Please fix this bug.