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 bespoke reports in the PBI service based on the initial dashboard/datamodel/content pack.
What are best practice backup procedures or does the Power BI platform on azure automatically manage backup & recovery ?
From an internal IT admin point of view : Obviously we can save local versions of the initial PBI desktop .pbix file as a backup…my question refers more to end user bespoke reports created in their PBI service. How do we manage & control these backups ?
Any suggestions are much appreciated…
I 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.
Looking at the API, this gives me a list of all workbooks by ID:
And then this is a direct link to download (replace the 1s with the ID):
We have asked this question to Microsoft and they mentioned that there is no strategy to take a backup, to migrate between tentants and to recover. This is definitely a need for any project. One thing we are trying to do and asking users to do is to connect or build the model in Power BI desktop, build any reports in desktop and publish to the service (We have 2 tenants and no way to migrate code between them). This way we minimize the risk as we have backups saved. There will definitely be a rework when we accidentally delete the content but atleast there is some backup to start with. Dashboards and Security part need to be done again.
Microsoft should think of something to backup the code from Service so customers can atleast maintain the backups on premises.
Unfortunately, developing reports in Desktop, then publishing to Web Service is the only option to accomodate for the lack of a backup/recovery strategy.
So then collaborative report development means managing multiple copies of the PBIX amongst the report developer community - with each PBIX / Dataset named differently.
Takes me back to the days of networking files & applications by sharing floppy disks amongst the collection of IBM AT PCs (i.e old skool style!).
What are the options for back-up/recovery for a Web Service Report that's created against the Dataset?
This is the case where report developers will be creating multiple Web Service Reports against a Dataset and it's entirely possible that one of them could delete not only their Report but someone else's Report stored in the same App Workspace.
We've been told by an on-site technical resource "Don't do that" (thank you, doctor).
There's no capabilty of saving the Web Service Report into another App Workspace and there's no option to download the Web Service Report.
Microsoft needs to step up with a solution to this issue PDQ!
I accidently found this topic and totally agree with the author and replies.
Nowadays users and clients are all awaring business continuity plan and of course PBI is also something people want to have a back up once any disaster happens. This should be an important feature in all aspects.
Adding to this topic, looking at the whole architecture, I'd also like to know what's the backup procedure at Microsoft side if the data stored in cloud encounters any risk?
I agree with the author and the recent reply. This is an important issue that we need some feedback on. I understand that since Octobe we can download a PBIX that we have uploaded and modified. But, what about other users who create custom reports based upon an organizational content pack. If I accidentally delete the dataset that is the source of the content pack....poof!....all custom reports are gone and irretrievable even after I recreate the dataset and put it back in the content pack. Or, if I accidentally delete the Content Pack itself....whoops, all custom reports based upon that pack are gone forever.
Someone Power Bi Microsoft technical support could answer this question? A simple click on "remove" can do great damage in all panels and reports built...
We are excited to announce the Power BI Super Users!
Overview of Power BI 2020 release wave 2!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.