MR IT Surgeon

Veeam Replicate to Azure with PowerShell & API. I’ve done a previous post on restoring VMs into azure using PowerShell Here: http://www.mritsurgeon.co.za/2020/02/restoring-multiple-vms-to-azure-part-2.html I wanted to further enhance this with Azure so that a scheduled script would remove older VM and restore newer VM, I additionally wanted there to be a revert option to older version of the VM through a VM snapshot.

Using Veeam Backup for Office 365 as DataSet for PowerBI using PowerBi Query.  I did a previous post on a self-service Dashboard which is built upon Veeam’s VBO APIs here: http://www.mritsurgeon.co.za/2020/07/single-install-script-for-veeam-backup.html I wanted to see if there was a way to use GET API method to share data with PowerBi as a data source. I previously did a post on Veeam Backup & Replication using its config SQL DB as Data Source for PowerBI here:

Single Install Script for Veeam Backup O365 Self Service Dashboard with Windows Web Server. A colleague Niels Engelen, Principal Analyst, Product Management created a great self-service web portal project that allows, customers & cloud providers to give access to O365 backups so that a user or customer may restore & manage his own O365 backup data.

Veeam with Microsoft PowerBI Creating a backup Statistics & analytics Dashboard with PowerBI With some time at home during lock down I decided to play round with PowerBi & learn. The easiest start for me was to plug this into a SQL database, looking around for a Data Set I thought what not easier than use the Veeam Config Database in my lab as its already holding rich data that I could transform into a Dashboard. I also have an deep knowledge into backup and can understand how & why to transform the Data Set. This was my first Time using PowerBi so bear with me .. First, I downloaded and installed PowerBI Desktop to my Veeam Backup Server (seemed easiest as data set was local to the Tool)