Integrate Alert Logic MDR with PowerBI

The following procedure will help you integrate Alert Logic® MDR entitlements with PowerBI. This report covers vulnerabilities, incidents, schedules, and appliances and agents. Additionally, the steps below will only need to be completed when the user first downloads and uses the PowerBI report.

Note: This article is intended for customers with MDR entitlements only. For customers with legacy entitlements, refer to the following article.

Download the Report

Alert Logic MDR customers must first download the PowerBI report. In order to download the PowerBI report, click here.

Note: Ensure the PowerBI file is saved to your computer and not just opened directly from the link.

Generate an API/Access Key

To use the PowerBI report, you will be required to create an API/Access Key for your UI login. Below are the steps on how you can set this up:

1. Log in to the Alert Logic console.
   
   
2. Click the main menu icon () at the top left of the screen.
   
   
3. Under Manage, click Users.
   
   
4. Find your account and click View, then click Access Keys.
   
   
5. Click Generate New Key and make a copy of your Access Key ID and Secret Key (you will need to click Show to view your Secret Key). You can also download these as file.
   
   

Set Up the PowerBI Report

1. Open up the supplied PowerBI report.
   
   
2. Go to File > Options and Settings > Options > Privacy, then select Always ignore Privacy Level Settings, and then click OK.
   
   
   
   
3. From the Ribbon at the top, select Home > Manage Parameters > Edit Parameters.
   
   
   
   
4. If the window below pops up, click Cancel.
   
   
   
   
5. On the Edit Parameters window, enter your Access Key ID and Secret Key from the Generate API/Access Key section above, and change the CID to be the ID of your Alert Logic Account, and then click OK.
   
   
   
   
6.  Select Apply Changes in the yellow ribbon that appears across the top.
   
   
   
   
7. The following window may appear three or four times; click Connect each time.
   
   
   
   
8. If successful, you should start to see data being loaded into the report.
   
   
   
   
9. Once completed, click File > Save to save the report, which will keep your Access Key and Secret Key. Going forward, all you will need to do is hit Refresh when opening the report to load in the most recent data (or update any of the date parameters).

Note: Alert Logic provides this template as a starting point for integration, but it is subject to change at any time.