How to Connect MS Secure Scores to Power Query?

Copper Contributor

The Microsoft 365 Defender Portal (https://security.microsoft.com/) has a 'Secure Score' page, which contains the following:

 

secure score screenshot.PNG

 

An overall secure score which is then broken down by Identity, Data, Device, and Application secure scores.

 

I would like to be able to pull these four scores into a Power BI report; however, I have had some difficulty in putting together a solution. This data seems like it could be found in the Microsoft Graph API, but MS seems to have made connecting Graph to Power Query rather difficult. I've tried other Defender APIs, but they all seem either outdated or out of scope for what I'm trying to pull. 

 

Can anyone advise? Thanks for reading. 

1 Reply

@datamole Hi there is a powerbi template for the secure score from the MDC team, you can get from the below link 

 

Microsoft-Defender-for-Cloud/Secure Score/PowerBI-SecureScoreReport at main · Azure/Microsoft-Defend...