Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Reply
Anonymous
Not applicable

Datamarts backup?

‎05-31-2022 03:46 AM

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?

Labels:
Message 1 of 5
3,021 Views
1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

‎05-31-2022 05:12 AM

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

Message 2 of 5
2,993 Views
0
4 REPLIES 4
Anonymous
Not applicable

‎10-06-2023 06:34 AM

Hi,


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

 

Thanks,

Sanjeewa

Message 5 of 5
2,084 Views
0
Anonymous
Not applicable

‎05-31-2022 06:46 AM

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

Message 4 of 5
2,986 Views
0
ibarrau
Super User
Super User

‎05-31-2022 05:12 AM

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

Message 2 of 5
2,994 Views
0
hkillen
Helper I
Helper I
In response to ibarrau

‎01-13-2023 08:16 PM

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?

Message 3 of 5
2,704 Views

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All