Forum Discussion
How to Connect MS Secure Scores to Power Query?
The Microsoft 365 Defender Portal (https://security.microsoft.com/) has a 'Secure Score' page, which contains the following:
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 https://learn.microsoft.com/en-us/power-query/connecting-to-graph. 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.
2 Replies
elieelkarkafi but https://portal.azure.com/ and https://security.microsoft.com/securescore are two different things though, aren't they? I read that article and didn't figure out how to access MS Defender Secure Score.
I also read somewhere that you could use Microsoft Graph security API to access the data, but haven't tried that option yet. I need to ask our IT to register the app.
datamole Hi there is a powerbi template for the secure score from the MDC team, you can get from the below link
