Data Disappears

[MominK]

Hi All,

I have had this recurring issue with data completely disappearing and ruining all my visualisations and losing all my measures randomly. This has happened on three occasions across two dashboard and two workspaces in the space of a few months. Extermely irritating as I have to rebuild this entire dashboard which is a lengthy task. I can reimport the data fine from SQL Server - but have to point the columns and create created columns and measures from scratch, as well as table transformations. 

Each occurrence doesn't seem to have any rhyme or reason - first two times I don't have any inkling as to what caused it. This time around, refreshed the data which completed with no apparent issues. Went into transform and changed a step that removed bottom rows, to remove less rows. Then Loaded and applied. No apparent issues. Hit save and didn't give me any prompt. Published and gave me "The Server Object is Not Connected" prompt I believe. Same issue when I tried to save. Closed and reopened to this monstrosity below. 

Please any help or ideas on saving backups etc would be appreciated.

[Bunmz_a]

Hello please were you able to find a solution. 

I just experienced the same issue after hours of work

[MominK]

Hi mate,

The solution ended up being that my computer had little memory left and so was impacting the RAM. So anytime the file would try to process a save or anything it wouldn't have enough memory to save and would corrupt the file (at least this is my understanding). I retrieved an older version of the file via OneDrive as I had previous versions/backups saved automatically in OneDrive in my organisation.

So try to clear any unnecessary files you have and clear up some storage in your computer and hopefully that will help.

[foodd]

Hello @Bunmz_a ,  woiud you please raise you question as a new Forum Post

instead of a reply to one alread marked a solved.   This will allow folks to 

view and reply to your post in the ptoper context.   

Issues

If you have found a true bug or issue, you can make a post to the forum to let others know (and that would be very nice of you to do so). But if you want to get it fixed, you should post it in the Issues/Ideas (it varies) area of the community. Specifically, you should post it here:

Power BI - https://community.powerbi.com/t5/Issues/idb-p/Issues
PowerAutomate - https://powerusers.microsoft.com/t5/I-Found-A-Bug/bd-p/BugFound
PowerApps - https://ideas.powerapps.com


Ideas

If you have a new idea for functionality or how something should work, you can certainly start a thread on the community to solicit feedback on your idea, but you should also post the idea in the ideas section of the website and solicit others to vote on your idea. The development teams use the Ideas area of the communities to build their development pipeline and a significant amount of weight is placed on Ideas that have lots of votes versus those that do not. The ideas areas of the communities are here:

Power BI - https://ideas.powerbi.com
PowerAutomate - https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
PowerApps - https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

[Anonymous · Accepted solution]

Hi @MominK ,

Depending on the information you provide, unexpected changes or errors in the data source or during the conversion process could cause the problem you describe. You can try the following steps to reduce the risk of losing work content in the future:

1. You can save the report as a Power BI Template file (PBIT). 

See the following documentation for more information:
Create and use report templates in Power BI Desktop - Power BI | Microsoft Learn

2. You can use "Copy a dashboard" feature of Power BI service. This does not save the underlying report or dataset, but it can quickly copy the dashboard configuration.

More details can be found in the following documentation:
Create a copy of a Power BI dashboard - Power BI | Microsoft Learn

3. Consider using an external script or tool to automate the process of backing up PBIX files and copying them to a secure location.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.