Forum Discussion
Creating e-mail security dashboard
Hi everyone I am trying to create a dashboard to show information regarding e-mail activity (e.g. number of e-mails received/sent, malware/spam e-mails blocked etc). We currently do this using a...
The built in connector for Microsoft Exchange is pretty limited IMO.
The best way to go about this is using the Microsoft Graph API.
- Register an Azure AD App
- Go to Azure Portal > "App Registrations" > "New Registration".
- Grant necessary permissions (Mail.Read, Calendars.Read, Contacts.Read).
- Generate a client secret.
- Use Power Query (M) or Power Automate to Pull Data
- Call the Microsoft Graph API (https://graph.microsoft.com/v1.0/me/messages for emails).
- Parse JSON responses in Power BI.
Please mark this post as solution if it helps you. Appreciate Kudos.