Forum Discussion
Issue Fetching Device, Data, App,Identity Scores from Microsoft Defender via Power Automate for BI
Hi everyone,
I'm currently developing a Power BI dashboard and trying to integrate Microsoft Defender scores — specifically Device Score, Data Score, App Score, and Identity Score — using Power Automate and Microsoft Graph API.
I've successfully set up the HTTP request in Power Automate and authorized the necessary Graph permissions, but I’m either not getting the expected values or receiving inconsistent/null responses for these specific scores.
Here’s a summary of what I’ve done so far:
Created an Azure App Registration with the following permissions: SecurityScore.Read.All, Vulnerability.Read.All.
Using Power Automate to call the endpoint:
https://graph.microsoft.com/beta/security/secureScoresAble to retrieve some data (like overall Secure Score), but the sub-scores like Device, App, Data, and Identity are either missing or not properly parsed.
Tried using Parse JSON and checked different fields, but still unable to extract correct values.
Has anyone successfully fetched these individual scores?
Any advice, sample expressions, or working response structures would be greatly appreciated!
Thank you in advance!
— Nandhana
Hi Nandhana___nk ,
Thank you for reaching out to the Microsoft Community Forum.
You are trying to integrate Microsoft Defender scores specifically Device Score, Data Score, App Score, and Identity Score, using Power Automate and Microsoft Graph API for a Power BI dashboard. You have set up the HTTP request and granted permissions (SecurityScore.Read.All, Vulnerability.Read.All), but you are receiving null or inconsistent values.
Please try below things to fix the issue.1. If beta is unstable, try to switch to v1.0 Endpoint.
https://graph.microsoft.com/v1.0/security/secureScores.
2. Check your schema includes both "averageComparativeScores" and c"ontrolScores". Use a sample response from Graph Explorer to generate the schema.
3. If "maxScore" is missing or zero, fetch metadata via the Control Profiles API to calculate accurate percentages.4. Use Power BI Desktop’s native connector for Microsoft Defender ATP. This may simplify data extraction and visualization.
Please refer Microsoft official document.Use the Microsoft Graph security API - Microsoft Graph v1.0 | Microsoft Learn
How to Calculate Identity SecureScore via Graph API? - Microsoft Q&A
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
4 Replies
Hi Nandhana___nk ,
Thank you for reaching out to the Microsoft Community Forum.
You are trying to integrate Microsoft Defender scores specifically Device Score, Data Score, App Score, and Identity Score, using Power Automate and Microsoft Graph API for a Power BI dashboard. You have set up the HTTP request and granted permissions (SecurityScore.Read.All, Vulnerability.Read.All), but you are receiving null or inconsistent values.
Please try below things to fix the issue.1. If beta is unstable, try to switch to v1.0 Endpoint.
https://graph.microsoft.com/v1.0/security/secureScores.
2. Check your schema includes both "averageComparativeScores" and c"ontrolScores". Use a sample response from Graph Explorer to generate the schema.
3. If "maxScore" is missing or zero, fetch metadata via the Control Profiles API to calculate accurate percentages.4. Use Power BI Desktop’s native connector for Microsoft Defender ATP. This may simplify data extraction and visualization.
Please refer Microsoft official document.Use the Microsoft Graph security API - Microsoft Graph v1.0 | Microsoft Learn
How to Calculate Identity SecureScore via Graph API? - Microsoft Q&A
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Hi Nandhana___nk ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
Hi @Nandhana___nk ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh