Scheduling the Power BI Premium Backup – Part 2
In this blog post I am going to detail how to create a schedule, test and confirm that the backup for the Power BI Premium dataset is successfully backed up.
This follows on from my first blog post: Automating the backup of Power BI Premium datasets/databases – Part 1
Getting the Power BI XMLA URL and Dataset name
Before creating the schedule, I need to get the Power BI XMLA URL and dataset name.
To do this I went into my App Workspace, then clicked on Settings and then clicked on Premium.
Once there I then copied the Workspace Connection, which is known as the PowerBiPremiumWorkspaceConnection
I copied “powerbi://api.powerbi.com/v1.0/myorg/PPU%20Spaces%20Testing”
Next to get the dataset name, in my App Workspace I then went to the dataset settings, and for my example I went to the dataset settings for A-HC
I then copied “A-HC”
Creating the Schedule to back up the Premium Dataset
Now I went into the Azure Portal to my runbook I had created earlier to create the schedule to back up my database.
This is what it looked like when I was in my Runbook, and I then clicked on Schedules.
I then clicked on Add a schedule.
There are 2 items that need to be completed, the first one is to link a schedule to your runbook (which is where I will create a schedule with the appropriate schedule name)
The second part is to configure the parameters to be run when this schedule is run.
I clicked on “Link a schedule to your runbook”
I then had to click on Add a schedule again.
I then had to put in a Name, this is important because this is your schedule name.
I typically have a schedule per dataset that I backup, so I name my schedule with the dataset name and how often.
I then also put in when I wanted it to start and to recur daily at 2AM in my local time zone.
I then clicked on Create to create the schedule.
This brings me back to my Schedule Runbook screen and this time I clicked on “Configure parameters and run settings”
For the Parameters this is where I now put in the PowerBiPremiumWorkspaceConnection and PowerBiDatasetName I gathered in the earlier steps.
I then clicked OK
I could now see the 2 items completed.
I clicked OK again.
I could then see my schedules in the Azure Portal
Then the following day I could then go and see the backup successful in the Azure Blob Storage location.
Thanks for reading I hope that this 2-part series has enabled you to ensure that you can successfully backup your Premium datasets, in the case you need to restore.
The great thing with the backup is that you could use this to restore it to another database or a new database and use it for testing purposes.
Any comments or suggestions are most welcome.