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.

[InsureBI]

I haven't been able to solve this problem, so I have decided to add some more details to see if that may be the cause of the error.

The table that I am trying to refresh (in PowerBI Desktop) has 5 new columns I have created, such as COUNTYSTATE = [COUNTY] & [STATE].  Are thes additional colums that I created the reason why the refresh is erroring out?  Do I need to delete them and re-create them after every refresh?

Note that if I import the new data file into another report in PowerBI desktop and look at the query, every thing in the script matches the query before refresh.

[Anonymous]

Hi InsureBI,

I create 5 new columns and then add new records in my text file, everything works well when I refresh data in Data View or Report View of Power BI Desktop. Would you mind sharing me your text file and PBIX file so that I can test them?

Thanks,
Lydia Zhang

[Anonymous]

Hi @InsureBI,

Do you refresh data in Data View or Report View of Power BI Desktop? I am not able to reproduce this error when imitating your scenario. Could you please share me your text file so that I can test it in my Power BI Desktop?

In addition, check that if the connection string is changed in Advanced Editor of Query Editor after refreshing data. Change text file path, re-add the connection string in Advanced Editor and refresh data and check if the error goes away.

Thanks,
Lydia Zhang

[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

[Anonymous]

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