Assistance Needed with Power BI Dashboard Development

Anonymous 

It sounds like you're working on an interesting project! Integrating data from Microsoft Defender for endpoint secure scores and mailbox usage data into Power BI can provide valuable insights into your organization's security posture and email infrastructure.

Here's a general outline of how you can approach importing this data into Power BI:

1. Microsoft Defender Secure Score Data:

   • Microsoft Defender for Endpoint provides a secure score that indicates the overall security posture of your organization's devices. You can access this data using Microsoft Graph API or Microsoft Defender Security Center API.
   • Start by obtaining the necessary permissions and credentials to access the API. You may need to work with your organization's Microsoft 365 administrator to obtain the required permissions.
   • Once you have the necessary permissions, use Power BI's "Get Data" feature to connect to the API and retrieve the secure score data. You may need to authenticate using OAuth or other authentication methods.
   • Import the data into Power BI and perform any necessary data transformations or calculations to prepare it for analysis. You can then create visualizations and dashboards to monitor your organization's secure score over time and identify areas for improvement.

2. Mailbox Usage Data:

   • Mailbox usage data such as mailbox size, number of emails in quarantine, and other mailbox statistics can be obtained from the Microsoft Graph API.
   • Similar to accessing secure score data, start by obtaining the necessary permissions and credentials to access the Microsoft Graph API.
   • Use Power BI's "Get Data" feature to connect to the Microsoft Graph API and retrieve the mailbox usage data. Authenticate using OAuth or other authentication methods.
   • Import the data into Power BI and perform any necessary data transformations or calculations.
   • Create visualizations and dashboards to analyze mailbox usage trends, monitor quarantine activity, and optimize mailbox storage.
     
     Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!