Forum Discussion
DavidMoss
Advocate V
Advocate Vbackup & recovery
After creating Power BI (PBI) datamodel & dashboards on PBI Desktop and publishing (some via content packs) what are our backup and recovery options? Conscious that end users create their own bes...
GilbertQ
Super User
Super UserHi there
As far as I am aware all the Power BI artifacts leverage the different Azure platforms, so that would mean that the data is persisted into Azure SQL Databases. So that would be where you could find information in terms of how data is backed up and restored in terms of Azure SQL Databases.
I am also going to go out and guess that the Power BI platform also uses Azure Analysis Services, which once again there will be details on how Azure Analysis Services is managed. And due to the way the data is being moved between being stored in Azure SQL databases and a form of Azure Analysis services, that should give a clearer indication of how the data is managed by Microsoft.
I do recall off the top of my head (And I stand to be corrected) is that local copies of data in Azure SQL database have 3 local copies stored, as well as a redundant copy in another data centre.
As far as I am aware all the Power BI artifacts leverage the different Azure platforms, so that would mean that the data is persisted into Azure SQL Databases. So that would be where you could find information in terms of how data is backed up and restored in terms of Azure SQL Databases.
I am also going to go out and guess that the Power BI platform also uses Azure Analysis Services, which once again there will be details on how Azure Analysis Services is managed. And due to the way the data is being moved between being stored in Azure SQL databases and a form of Azure Analysis services, that should give a clearer indication of how the data is managed by Microsoft.
I do recall off the top of my head (And I stand to be corrected) is that local copies of data in Azure SQL database have 3 local copies stored, as well as a redundant copy in another data centre.
deepu299Advocate V
Advocate VI think, the problem is, when a copy is accidentally deleted by any user, all the copies will be deleted because of the sync between data centers. These 3 copies are useful only when there is a failure from Azure side, not from client side.
- GilbertQFor sure, that is why I guess it would be good if the PBIX had version control so you could easily upload the current or previous option.
Looking at the API, this gives me a list of all workbooks by ID:
http://<SERVERNAME>/Reports/api/v2.0/catalogitems
And then this is a direct link to download (replace the 1s with the ID):
http://<SERVERNAME>/Reports/api/v2.0/catalogitems(111111-1111-1111-1111-1111111111)/Content/$value
