Forum Discussion
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...
If you go line by line and update each source individually, instead of using the refresh button in the toolbar you can find the specific error in the specific table that is causing the problem. For some reason this error causes the entire chain to break and prevents the data from updating. I discovered a blank row had been entered in one of my tables. Because this table had relationships associated with that row, it broke everything. I love Power BI, but the error messages are criptic and extremely unhelpful.