Dates disappear when Refreshing data in Power BI Desktop

[Mega79]

Hi everyone! I'm having problems with some Reports that I want to Refresh at least 4 times a month.

The data comes from one Excel database downloaded from an intranet portal. This files have at least 10 000 lines.

I insert more data into this Excel database every week before using Power BI. Once I have all new data inside the Excel database I then open Power BI Desktop and hit the Refresh botton to update with the new data.

Here's the problem: every time I hit the Refresh data, all of my "Date" type columns go blank... I do not know why this happens all the time but apparently I'm doing something wrong.

Can anyone please help me with this?

Thanks in advance for your help.

[ankitpatira]

@Mega79 have you ensured that column format in excel and power bi is of same type ie date ?

[Mega79]

Yes, they are both in date format but when I refresh the data I get this message now:

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

[Eric_Zhang]

@Mega79

So the problem only happens when hitting "refresh"? What happens when redo "get-data" from the excel, do all the dates load well?

[Mega79 · Accepted solution]

Actually, it was a problem with the connection of Binary file .xlsb vs .xlsx.

Thanks anyway for your help!