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.

[v-yifanw-msft · 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.