Forum Discussion

Mega79's avatar
Mega79
Icon for Helper I rankHelper I
10 years ago
Solved

Dates disappear when Refreshing data in Power BI Desktop

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.

Need Help
  • Mega79's avatar
    Mega79
    10 years ago

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

    Thanks anyway for your help!

4 Replies

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion
    10 years ago

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

    • Mega79's avatar
      Mega79
      Icon for Helper I rankHelper I
      10 years ago

      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's avatar
        Eric_Zhang
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        Mega79

         

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