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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I restarted my pc to clear any errors in ODBC connection and then refreshed the datafiles and the error above disappeared.

  • InterSimi's avatar
    InterSimi
    Helper II
    8 years ago

    I had this issue when importing in multiple spreadsheets and refreshing.

     

    I resolved this in two steps:

     

    1. Identify the excel spreadsheet causing the issue.
    2. Step through the Advanced query editor and identify the ofending line

     

    In order to complete step 1. I opened up Query Editor and refeshed each source spreadsheet at a time, until I hit the error. This identifies whe soure of the issue.

     

    In order to complete step 2. I then opened up Advanced Query Editor and copied the text into Notepad. I then removed all of the steps and added them in one by one and refreshed each time, until I hit the error again. Things to remember when doing this (I found out by trial and error)

     

    In my case, adding them all back in, line by line still resolved the issue, so this does look like a bug, but is easily resolved.