Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Datamarts backup?

Is there anyway to backup datamart definition in case someone deletes it by accident or something happens?

In case of reports we store pbix files for managing versions of datasets and reports but in this case, how do you manage that?

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

Hi. Datamarts are so new that it might have many features that are not there yet. This is one of them. There is nothing related to backups yet. Stay tuned with the power bi announcements, maybe in the future months something might be shown there.

If you want to manage version you can just open a PBI Desktop and connect to the Azure SQL Database instead of using the auto generated direct query dataset.

Regards


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

Happy to help!

LaDataWeb Blog

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi,


I have just started using datamart . The datamart looks good, but concern with backups. Can we recover if datamart crashes?

 

Thanks,

Sanjeewa

Anonymous
Not applicable

Thank you very much.
I didnt know connecting to Azure SQL Database could crear a backup

ibarrau
Super User
Super User

Hi. Datamarts are so new that it might have many features that are not there yet. This is one of them. There is nothing related to backups yet. Stay tuned with the power bi announcements, maybe in the future months something might be shown there.

If you want to manage version you can just open a PBI Desktop and connect to the Azure SQL Database instead of using the auto generated direct query dataset.

Regards


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

Happy to help!

LaDataWeb Blog

Any update on this?   I was unable to open my Datamart...so I had to recreate it.  Took a lot of time.  It's a single point of failure.  I've got to be able to backup the Datamart.  Any way to do this?

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.