Configure Azure Backup reports

This article shows steps to follow to configure reports for Azure Backup by using a Recovery Services vault. It also shows how to access reports by using Power BI. After you finish these steps, you can go directly to Power BI to view, customize, and create reports.

Important

From 1st November, 2018, some customers may see issues in loading the data in Azure Backup App in Power BI, saying “We found extra characters at the end of JSON input. The exception was raised by the IDataReader interface.” This is due to a change in the format in which data is loaded into the storage account. Please download the latest App (version 1.8) to avoid this issue.

Supported scenarios

  • Azure Backup reports are supported for Azure virtual machine backup and file and folder backup to the cloud by using the Azure Recovery Services Agent.
  • Reports for Azure SQL Database, Azure File Shares, Data Protection Manager, and Azure Backup server aren't supported at this time.
  • You can view reports across vaults and subscriptions, if the same storage account is configured for each of the vaults. The storage account selected must be in the same region as the Recovery Services vault.
  • The frequency of scheduled refresh for the reports is 24 hours in Power BI. You also can perform an ad-hoc refresh of the reports in Power BI. In this case, the latest data in the customer storage account is used to render reports.

Prerequisites

  • Create an Azure storage account to configure it for reports. This storage account is used to store reports-related data.
  • Create a Power BI account to view, customize, and create your own reports by using the Power BI portal.
  • Register the resource provider Microsoft.insights, if it's not registered already. Use the subscriptions for the storage account and the Recovery Services vault so that reporting data can flow to the storage account. To do this step, go to the Azure portal, select Subscription > Resource providers, and check for this provider to register it.

Configure storage account for reports

Follow these steps to configure the storage account for a Recovery Services vault by using the Azure portal. This is a one-time configuration. After the storage account is configured, you can go directly to Power BI to view the content pack and use reports.

  1. If you already have a Recovery Services vault open, go to the next step. If you don't have a Recovery Services vault open, in the Azure portal, select All services.

    • In the list of resources, enter Recovery Services.
    • As you begin typing, the list filters based on your input. When you see Recovery Services vaults, select it.

      Create Recovery Services Vault step 1

    • The list of Recovery Services vaults appears. From the list of Recovery Services vaults, select a vault.

      The selected vault dashboard opens.

  2. From the list of items that appears under the vault, under the Monitoring and Reports section, select Backup Reports to configure the storage account for reports.

    Select Backup Reports menu item step 2

  3. On the Backup Reports blade, select the Diagnostics Settings link. This link opens the Diagnostics settings UI, which is used to push data to a customer storage account.

    Enable Diagnostics step 3

  4. Select Turn on diagnostics to open a UI to use to configure a storage account.

    Turn on diagnostics step 4

  5. In the Name box, enter a setting name. Select the Archive to a storage account check box so that reporting data can start flowing into the storage account.

    Enable diagnostics step 5

  6. Select Storage account, select the relevant subscription and the storage account from the list for storing reporting data, and select OK.

    Select storage account step 6

  7. Under the Log section, select the AzureBackupReport check box. Move the slider to select a retention period for this reporting data. Reporting data in the storage account is kept for the period selected by using this slider.

    Save storage account step 7

  8. Review all the changes, and select Save. This action ensures that all your changes are saved, and the storage account is now configured to store reporting data.

  9. The Diagnostic settings table now shows the new setting enabled for the vault. If it doesn't appear, refresh the table to see the updated setting.

    View diagnostic setting step 9

Note

After you configure reports by saving the storage account, wait for 24 hours for the initial data push to finish. Import the Azure Backup App in Power BI only after that time. For more information, see the FAQ section.

View reports in Power BI

After you configure a storage account for reports by using a Recovery Services vault, it takes around 24 hours for reporting data to start flowing in. After 24 hours of setting up a storage account, follow these steps to view reports in Power BI. If you wish to customize and share the report, create a workspace and do the following steps

  1. Sign in to Power BI.
  2. Select Get Data. In the More ways to create your own content, select Service content packs. Follow the steps in the Power BI documentation to connect to a service.

  3. In the Search bar, enter Azure Backup and select Get it now.

    Get content pack

  4. Enter the name of the storage account that was configured in the previous step 5, and select Next.

    Enter storage account name

  5. Using Authentication method "Key", enter the storage account key for this storage account. To view and copy storage access keys, go to your storage account in the Azure portal.

    Enter storage account

  6. Select Sign in. After sign-in is successful, you see an importing data notification.

    Importing content pack

    After the import finishes, you see a Success notification. If the amount of data in the storage account is large, it might take a little longer to import the content pack.

    Import success content pack

  7. After data imports successfully, the Azure Backup content pack is visible in Apps in the navigation pane. Under Dashboards, Reports, and Datasets, the list now shows Azure Backup.

  8. Under Dashboards, select Azure Backup, which shows a set of pinned key reports.

    Azure Backup dashboard

  9. To view the complete set of reports, select any report in the dashboard.

    Azure Backup job health

  10. Select each tab in the reports to view reports in that area.

    Azure Backup reports tabs

Frequently asked questions

How do I check if reporting data has started flowing into a storage account?

Go to the storage account you configured, and select containers. If the container has an entry for insights-logs-azurebackupreport, it indicates that reporting data has started flowing in.

What is the frequency of data push to a storage account and the Azure Backup content pack in Power BI?

For Day 0 users, it takes around 24 hours to push data to a storage account. After this initial push is finished, data is refreshed with the frequency shown in the following figure.

  • Data related to Jobs, Alerts, Backup Items, Vaults, Protected Servers, and Policies is pushed to a customer storage account as and when it's logged.

  • Data related to Storage is pushed to a customer storage account every 24 hours.

    Azure Backup Reports data push frequency

  • Power BI has a scheduled refresh once a day. You can perform a manual refresh of the data in Power BI for the content pack.

How long can I retain reports?

When you configure a storage account, you can select a retention period for report data in the storage account. Follow step 6 in the previous "Configure storage account for reports" section. You also can analyze reports in Excel and save them for a longer retention period, based on your needs.

Will I see all my data in reports after I configure the storage account?

All the data generated after you configure a storage account is pushed to the storage account and is available in reports. In-progress jobs aren't pushed for reporting. After the job finishes or fails, it's sent to reports.

If I already configured the storage account to view reports, can I change the configuration to use another storage account?

Yes, you can change the configuration to point to a different storage account. Use the newly configured storage account while you connect to the Azure Backup content pack. Also, after a different storage account is configured, new data flows in this storage account. Older data (before you change the configuration) still remains in the older storage account.

Can I view reports across vaults and subscriptions?

Yes, you can configure the same storage account across various vaults to view cross-vault reports. Also, you can configure the same storage account for vaults across subscriptions. Then you can use this storage account while you connect to the Azure Backup content pack in Power BI to view the reports. The storage account selected must be in the same region as the Recovery Services vault.

Troubleshooting errors

Error details Resolution
After you set up the storage account for Backup Reports, Storage account still shows Not Configured. If you configured a storage account successfully, your reporting data flows in despite this issue. To resolve this issue, go to the Azure portal and select All services > Diagnostics settings > Recovery Services vault > Edit setting. Delete the previously configured setting, and create a new setting on the same blade. This time, in the Name box, select service. Now the configured storage account appears.
After you import the Azure Backup content pack in Power BI, a "404- container is not found" error message appears. As previously mentioned, you must wait 24 hours after you configure reports in the Recovery Services vault to see them correctly in Power BI. If you try to access the reports before 24 hours, this error message appears because complete data isn't yet present to show valid reports.

Next steps

After you configure the storage account and import the Azure Backup content pack, the next steps are to customize reports and use a reporting data model to create reports. For more information, see the following articles.