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

[YunJ]

Hi,

I have a raw data like this. (Please pay attention the Date column)

When I refresh in power bi, it fails to refresh.

However, when I change the Date type in power bi as Whole number, it can refresh successfully.

I'm wondering is there a way to fix this? because I need the Date type as date in power bi.

Thanks for your time.

[YunJ · Accepted solution]

I found only if go to power query, and change the Date type as date, it will refresh successfully.

[amitchandak]

@YunJ , Open power Query and check for the error in details. I think it issue with date data type because of format change

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs