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
Select Get Data at the bottom of the left navigation pane.
In the Services box, select Get.
Select Azure Security Center > Get.
Specify your Subscription ID. See details on finding those parameters below.
For Authentication Method, select oAuth2 > Sign In. When prompted, enter your Azure credentials.
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.
- Try asking a question in the Q&A box at the top of the dashboard
- Change the tiles in the dashboard.
- Select a tile to open the underlying report.
- While your dataset will be schedule to refreshed daily, you can change the refresh schedule or try refreshing it on demand using Refresh Now
The content pack includes insights around resource security stat, alert analysis and prevention analysis.
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).
There are two easy ways to find your Subscription Id.
- From https://portal.azure.com -> Browse -> Subscriptions -> Subscription Id
- 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.
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.