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
RV1's avatar
RV1
Helper I
8 years ago

Hi there,

 

I have started getting the same error in the last few days. My model is a combination of SQL Server Tables. Excel files and Aggregated Tables. I have tried the following:

 

a. Checked the integrity and data format of my Excel Files

b. Checked the relationships between tables

c. Rebooted the system

 

I have asked the IT team to reboot the SQL server tonight.

 

Despite all efforts, I keep getting the errors. And each time, the error is on a different table. However, if I refresh the tables individually, they work just fine.

 

Is anybody able to point me to the right direction?

 

Many thanks.

RV1's avatar
RV1
Helper I
8 years ago

OK. I am sorted. We had a duplicate record. As soon as that was fixed, all errors disappeared. But I had to refresh each table individually to narrow down the problem.