Azure Backup Reports in PowerBI

If you use Azure backups – you can pull all of the report info into PowerBI dashboard and also Microsoft Teams, Read on to see how to configure this in AzureAzure Backup reports are supported for Azure VM backup and file/folder backup to Azure using Azure Recovery Services Agent.  Reports for Azure SQL, DPM and Azure Backup Server are not supported at this time

The following prerequisites are required:

  • Create an Azure storage account to configure it for reports. This storage account is used for storing reports
  • Create a Power BI account to view, customize, and create your own reports using Power BI portal
  • Register the resource provider Microsoft.insights if not registered already, with the subscription of storage account and also with the subscription of Recovery Services vault to enable reporting data to flow to the storage account. To do the same, you must go to Azure portal > Subscription > Resource providers and check for this provider to register it:

2018-05-31 16_23_52-Clipboard.png

Storage Account:

2018-05-31 16_27_00-Clipboard

Configure Backup Reports in RSV:

2018-05-31 16_29_52-Clipboard

2018-05-31 16_32_38-Clipboard.png


Now we can head over to PowerBI portal to setup the reports, browse to:

We have to install the ‘Azure Backup App’, you can search for it and click ‘Get it Now’

2018-05-31 16_35_04-Clipboard.png

Now we must link the storage account that we created earlier which stores all the backup reports data:

2018-05-31 16_38_12-Clipboard.png

The next screen will prompt for a storage key associated with the storage account – this can be retrieved from the Azure portal:

2018-05-31 16_40_07-Clipboard

We can now access Azure Backup Reports in PowerBI and customize it as we wish:

2018-05-31 16_42_44-Azure Backup - Power BI