We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
What is the best way to get MS Defender Attack Simulation training results into Power BI, specifically the Users results?
Currently we're downloading for each campaign to Excel and then connecting the spreadsheet to Power BI. But was wondering what the best way to get to this information directly into Power BI without having to do this manual process.
Here is the Graph API call that returns the summary level information about a particular campaign: https://graph.microsoft.com/v1.0/security/attackSimulation/simulations/enter-your-simulation-#-here
But we are looking for the same data and columns available when you click the 'Export' button that downloads a .csv file from the simulations 'Users' tab. We can't find if there is a call that exists to get this detailed information.
Not being familer with that specific product but do the APIs provide you access to this data?
Access the Microsoft Defender for Endpoint APIs - Microsoft Defender for Endpoint | Microsoft Learn
I would think the "WEB" connector using an API might be the most robust way of getting the data from your cloud service.
@RossEdwards I'm not entirely sure if the API provides simulation results. That's why I'm hoping if someone has done this before to give me a start in the right direction. I'll go over the Endpoints in the meantime.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 57 | |
| 38 | |
| 33 | |
| 19 | |
| 16 |
| User | Count |
|---|---|
| 68 | |
| 66 | |
| 41 | |
| 34 | |
| 25 |