Activity: Monitoring Azure SQL Database with Log Analytics and Power BI

In this activity, we'll learn how to import Log Analytics workspace data into Power BI, and we'll create a report in Power BI.

Note

The purpose of the activity is not to create a performance monitoring dashboard. The purpose is to explain how to get Log Analytics workspace data into Power BI, which can then be used to create a dashboard as and when required.

Follow these steps to complete the activity:

1. Log in to the Azure portal. Search for and open the previously created Log Analytics workspace:
   

   Figure 10.51: Navigating to the created Log Analytics workspace

2. On the Log Analytics workspace page, find and open Logs:
   

   Figure 10.52: The Log Analytics workspace

3. On the New Query 1 page, copy and paste the following query:

   AzureMetrics
   | where ResourceProvider=="MICROSOFT.SQL" | where ResourceId contains "/ SERVERS/"
   | where ResourceId contains "/DATABASES/&quot...