Forum Discussion

dnaman's avatar
dnaman
Helper I
8 years ago
Solved

When refreshing data, my data disappears

Hi All,   Hopefully this is a simple question. I have a PBIX file that i created, with an Excel (.xls) file as my data source (from an external system).   I created a couple reports/dashboards us...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi dnaman,

     

    In your scenario, first did you get any error message when you refresh your data? And did you change the data type of the columns in your data source file? As you should know that once you imported the data into Power BI, it will generate corresponding data types for the columns automatically. And if you have changed the source file and refresh the source, Power BI will not change the data type automatically. That's may be the issue.

     

    By the way, if you can share us your original source file and the updated one with One Drive or Google Drive. We can make some tests and provide more proper suggestions.

     

    Thanks,
    Xi Jin.

dnaman's avatar
dnaman
Helper I
8 years ago

Thanks i basically just used my original file, and copied and pasted the data as values, to keep the original formatting of the original file and it worked

Charlemagne's avatar
Charlemagne
New Member
7 years ago

I also lost my data model twice before I investigated further, and found the post below:

 

https://social.technet.microsoft.com/Forums/ie/en-US/64310a51-79fa-4437-8035-7c034f72a95b/powerpivot-in-excel-2016-data-model-lost-empty?forum=excel

 

In short, the issue goes back to October 2015.  The data model is lost when you close Excel and save via the dialog box (rather than save before closing the program).  It would be nice to have a prompt fix to this issue, since I am avoiding using Power Pivot / the Data Model for that reason as I don't want to lose my work again.