Forum Discussion
CanerHan
Feb 22, 2022Copper Contributor
API Power BI Report
Hallo community, i have to build a Power BI Report. I need all incidents and their alerts from Sentinel. Which API can get me the data for all incidents and alerts? I am confused because there ...
GaryBushey
Feb 22, 2022Bronze Contributor
CanerHan Your best bet is to create the needed query in MS Sentinel's Logs area and then use the Export command in the header to export to PowerBI. It will create a text file that will tell you how to get the data into PowerBI.
- Clive_WatsonFeb 22, 2022Bronze ContributorThis thread may help if you need a Incident and Alerts type query (as an example you can tweak): https://techcommunity.microsoft.com/t5/microsoft-sentinel/how-to-get-the-real-count-of-incidents-in-microsoft-sentinel/m-p/3102751