Blog Post

Microsoft Defender for Cloud Blog
3 MIN READ

Secure Score Over Time Power BI Dashboard

amit_magen's avatar
amit_magen
Icon for Microsoft rankMicrosoft
Oct 21, 2020

As organizations start to use Azure Security Center Secure Score to measure their journey to a better cloud security posture, it becomes important to understand how this secure score is progressing over time. With our new Power BI dashboard, you will be able to track your secure score progress over time and your resources health 

 

The dashboard contains out-of-the-box reports that will help you analyze your security status by providing the necessary information to investigate changes in your score over time. 

By using the dashboard you can infer actionable insights regarding your security statusFor examplediscover which resources should be addressed due to recent changes and which areas require more attention. The dashboard consists of two reports 

  • Secure Score Summary provides summarized data regarding your score progress. 
  • Resources Summary provides summarized data regarding your resources health. 

In the Secure Score Summary report, you can use the Secure score over time per subscription chart to see changes in the score. In case you observed a dramatic change in your score, you can find in the detected changes that may affect your secure score table which changes might have caused the score to drop. This table presents deleted resources, newly deployed resources, or resources that their security status changed for one of the recommendationsA sample of this Power BI dashboard is shown below: 

 

Fig 1: Secure Score Summary report

 

Let’s use a sample scenario where the secure score dropped by 10%. Looking at the detected changes table, you found VM that its security status changed on the same day. If the VM changed to unhealthy for one of the recommendations, it can explain the dropYour next step will be to investigate what was the change and which recommendation you need to remediate to make this resource healthy again. To do that you can use the Resources that changed their security status table, which presents more details about the changed resources Another option is to use Unhealthy resources over time per recommendation that presents the number of unhealthy resources for each recommendation every day. Looking at this chart you can observe recommendations that their number of unhealthy resources increased on the same date the score was dropped. Pressing on the recommendation line will filter the Resources that changed their security status table according to the date and recommendation you choose. Once you find the resource and the recommendation that caused the score to drop, you can contact the resource owner for remediation.  

 

In addition to the over time tracking, you can leverage the Resources Summary report to understand your current security status. Using the Controls status sorted by potential impact chart you can see the percentage of unhealthy resources per control, and in case you want to drill down to a specific recommendation you have the Recommendations current state table. 

 

Fig 2: Resources Summary report

 

More details about the dashboard and installation guidelines can be found here. 

 

Send feedback 

Have you tried the dashboard? Help us getting better by filling this form. Your feedback is highly appreciated. 

 

Reviewers 

Yuri Diogenes - Principal Program Manager, CxE

Miri Landau - Senior Program Manager, Azure Security Center

Moshe Israel - Senior Data Scientist, Azure Security Center

Shahar Weiss - Senior Software Engineer, Azure Security Center

Updated Oct 21, 2020
Version 2.0

5 Comments

  • paulguckian's avatar
    paulguckian
    Copper Contributor

    Love the template, and would add a +1 for the similar with Identity Score

    I get the error message "This app hasn't been listed on AppSource. You don't have permissions to install this app."

    Would it be possible to list this on AppSource, please?

  • joetw's avatar
    joetw
    Copper Contributor

    Hi Team,

    I'm trying to create a power bi report or dashboard to show current and closed/remediated container and VM vulnerabilities. Is there a kusto query available that I can use to pull this data in CSV. Any help will be highly appreciated. 

    Thanks,

    Joe

     

  • sonnysiah2022's avatar
    sonnysiah2022
    Copper Contributor

    Hi,

     

    I have try out the integration but not so sure how to set the PowerBI authentication using Org with OAuth2, cannot found where to set it?.

     

    4. Perform authentication using organizational account with OAuth2 as the authentication method for your Log Analytics workspace.

     

    Thanks.

  • Dean_Gross's avatar
    Dean_Gross
    Silver Contributor

    would it be possible to do this same thing but for the Identity Secure Score from Azure AD?

  • MisterCloudTech's avatar
    MisterCloudTech
    Copper Contributor

    Great option, just got a customer request specifically on this today.
    Thanks 🙂