• 3 min read

Gain business insights using Power BI reports for Azure Backup

This article talks about preview of Azure Backup Reports using Power BI content pack.

Azure Backup announced the support for alerting and monitoring in August 2016. Taking it a step further, we are excited to announce preview of Azure Backup Reports using Power BI. Azure Backup Reports provide the ability to gauge backup health, view restore trends, and understand storage usage patterns across subscriptions and across vaults. More importantly, this feature provides complete power to you to generate your own reports and build customizations using Power BI.

Key Benefits

This feature provides the following capabilities and gives complete control to the customers for building reports:

  1. Cloud based reports – You do not need to setup a reporting server, database, or any other infrastructure since everything is completely managed on the cloud. All you need is a storage account and Power BI subscription. The Power BI free tier supports reports for backup reporting data under 1 GB per user.
  2. Cross subscription and cross vault reports – You can view data across subscriptions and vaults to get a big picture view, track organization SLAs, meet compliance requirements across departments, etc.
  3. Open data model –  You can now create your own reports and customize existing reports since the Azure Backup management data model is publicly available.
  4. Data visualization –  You can take advantage of Power BI’s data visualization capabilities to perform business analytics and share rich data insights.
  5. Access control – Power BI also provides the capability to create organizational content packs, which can be used for sharing selected reports inside the organization and restricting access to reports based on their requirements.
  6. Export to Event Hub and Log Analytics – Besides the ability to export the data to storage account and connect to it using Azure Backup content pack in Power BI, you can also export reporting data to Event Hub and Log Analytics to leverage it in OMS and other tools for further analysis.

Analyzing data using Power BI

You can configure Azure Backup reports using recovery services vault and import Azure Backup content pack in just a few steps. Once done, use the Azure Backup dashboard in Power BI to create new reports and customize existing ones using filters like vault, protected server, backup items, and time.

1. Storage

Storage reports track backup storage and protected instances over time. You can answer the following business questions using these reports:

  • Which protected servers had the highest protected instances last month?
  • Which protected servers use the most backup storage and have highest impact on billing?Azure Backup - Storage Reports

2. Job Health

Job Health reports provide trends about backups and restores impacted by job failures, cause of these failures, and statistics about failed and successful jobs. You can answer the following business questions using these reports:

  • Was backup job failure higher than 10% last week?
  • What were the top causes of job failures yesterday?
  • Which backup items were impacted by these job failures?

In the image below, Backup has been selected in Distribution of Failed Jobs donut chart; this updates all other visuals on this tab with backup failures related data.

Azure Backup - Job Health Reports

3. Backup Items

Backup Item reports provide details about backup schedule, data transferred, failure percentage, and last successful backup time. You can answer the following business questions using these reports:

  • Which backup items had maximum data transferred last week?
  • Are these items backed up during the same time period in a day?
  • Which backup items had no successful backups yesterday?

Azure Backup - Backup Item Reports

4. Job Duration

Job Duration reports provide insights into backup and restore job duration. You can answer the following business questions using these reports:

  • Which virtual machines had longest running jobs last week?
  • Which folders take longest time to restore?

Azure Backup - Job Duration Reports

5. Alerts

Alert reports provide distribution of active alerts, backup items that generate these alerts, and trends about alert resolution time. You can answer the following business questions using these reports:

  • Which data sources generated the most critical alerts in last week?
  • What is the trend of alert resolution since last few months?
  • Has the critical alert count reduced after latest version update?

Azure Backup - Alert Reports

Related links and additional content