Connect to Azure Security Center with Power BI

Get insights into your Azure workload security by connecting your Azure Security Data with Power BI. Power BI automatically creates a dashboard and report on top of your Azure Security Center data enabling you to analyze and explore the data.

Connect to the Azure Security Center content pack for Power BI.

How to connect

  1. Select Get Data at the bottom of the left navigation pane.

  2. In the Services box, select Get.

  3. Select Azure Security Center > Get.

  4. Specify your Subscription ID. See details on finding those parameters below.

  5. For Authentication Method, select oAuth2 > Sign In. When prompted, enter your Azure credentials.

  6. After approving, the import process will begin automatically. When complete, a new dashboard, report and model will appear in the Navigation Pane. Select the dashboard to view your imported data.

What now?

What's included

The content pack includes insights around resource security stat, alert analysis and prevention analysis.

System requirements

This content pack requires access to a subscription ID with Azure Security Center enabled. See more details in the Azure Security Center in the Azure Portal.

The content pack also requires the user to connect with an organizational account (not a personal account).

Finding parameters

There are two easy ways to find your Subscription Id.

  1. From https://portal.azure.com -> Browse -> Subscriptions -> Subscription Id
  2. From https://manage.windowsazure.com -> Settings -> Subscription Id

Your subscription ID will be long set of numbers and characters, similar to the example in Step #4 above.

Troubleshooting

The data may take some time to load depending on the size of your account. If you hit an error during login, please confirm your parameters and the account has Azure Security Center enabled.

If the content pack loads but doesn't show any data, please confirm you're connecting with an organizational account. Although personal accounts are supported by Azure Security Center, the API (and therefore the content pack) does not return the expected values if the user connects with a non-organizational account. Please provide access to an organizational account and try connecting again.

Next steps

Get started in Power BI

Get data in Power BI