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.
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?
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.
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
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.