Forum Discussion
Data refresh error: OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D.
I just faced the same issue and fixed it by changing the format of column crating it. Here is the story:
I connected a table which is sitting down on the cloud. One of my column which is actually a date was exported as “Whole number”. I did my report and ran several refreshes as new entries were coming. So far everything was working well. After the third refresh, I realized that I needed to add a new chart in my report using the date column. I changed the format form "whole number" to "DateTime" type. And when I did the fifth refresh, this is where I got this error message. When I put it back to “whole number” format, I was able to refresh and did not get an error message.
I fixed the same issue. In my case it was also a problem of date format.
If you imported once a column of dates but without a 'date' type on Excel then Power BI sees it as a number. In Modify request > step "modified types" there is something like :
= Table.TransformColumnTypes(#"Columns .... {{"Source.Name", type text}, {"Date", Int64.Type}, ....
I have solved it by changing {"Date", Int64.Type} to {"Date", type date} .... and by checking my data in Excel is in the correct 'date' type.