Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
arock-well
Responsive Resident
Responsive Resident

Getting Data from MS Defender Attack Simulation Training Results

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.

 

arockwell_0-1719441502078.png

 

3 REPLIES 3
arock-well
Responsive Resident
Responsive Resident

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.

RossEdwards
Solution Sage
Solution Sage

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.


I will lose access to this profile after June 30 2026 and will not be able to reply.

@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.

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors