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 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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Mega79,

You can upload the Excel file to OneDrive and share the link here.


Thanks,
Lydia Zhang