Forum Discussion

Mega79's avatar
Mega79
Helper 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 l...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi Mega79,

    I can reproduce the above error when refreshing data in Data view.

    However, when I save the Excel file as a .xlsx file rather than .xlsb file, import the .xlsx file into Power BI Desktop, add additional records in the .xlsx file and refresh data in Power BI, everything works well. Could you please test if the process works in your Power BI Desktop? If it works, please recreate reports after importing the .xlsx file into Power BI Desktop.

    Thanks,
    Lydia Zhang

Mega79's avatar
Mega79
Helper I
10 years ago

Thanks so much for your help Lydia!

You were right about the binary file. I changed the entire database into .xlsx and everything works perfectly.

 

Thanks again!

MyraMa's avatar
MyraMa
Advocate II
8 years ago

Hi AnonymousLydia,

 

I got the similar problem. I've done what you mentioned (check date type at both places), my file is already a .xlsx file. It doesn't show date at all when I load excel data into Power BI. Could you please help?

 

My excel file is shared here: 

https://radacad-my.sharepoint.com/personal/myra_ma_radacad_com/_layouts/15/guestaccess.aspx?docid=12eac8784c484449cb73f83381ec57e90&authkey=AUMWtGGSVhLOXEOYTBVGAwk&expiration=2017-12-21T11%3A00%3A00.000Z&e=9ce280b2797b4b1b9acf09d017b6ffdd

 

 

Really appreciate your help.

Myra