Data refresh error: OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D.

[InsureBI]

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 new file.

The error message says: OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D.  This happened in the old version of the Desktop as well as the new version (i.e, latest version that I downloaded and installed today).

Has anyone seen this before? Can I get some tips on troubleshooting this error?  Thank you.

[Anonymous]

Hi,

I am also facing same issue. I just delete the connection and try to reconnect it again

Regards,

Kuldeep

[ankitpatira]

@InsureBI I have seen similar issue when updates to power query happens in excel. I would say report this to microsoft.

[ivanls]

I could detect the error, it turns out that there was a relationship between two files that one of my collaborators made without knowing that it would affect, I eliminated the realtion between those two documents and it worked, the error disappeared.
I hope they serve

[SacheeT]

This is one of real cases for the error. Breaking the links to other exel files will solve the issue.