Feb 14 2020 08:25 AM
hey all,
I'm creating a PowerBI dash to report on some SOC statistics for the wider IT org to look at. Getting an alert view in is easy using a KQL query in PowerBI format.
But I don't see how I can get to Incident statistics. Looking to show Nr of incidents per status / priority .. etc. Is there a way to do this?
thanks!
Feb 14 2020 10:51 AM
Solution@mclaes Take a look at my blog post to see if that answers your questions. https://www.garybushey.com/2020/01/20/azure-sentinel-incidents-in-powerbi/
Feb 19 2020 05:57 AM
Feb 19 2020 06:23 AM
@mclaes Thanks for that tip. Perils of cut and paste :)
Oct 12 2023 02:12 AM
thank you for the blog. However this M code doesnt allow to refresh the dataset on power bi Service (cloud) because it contains dynamic sources that refrains it to refresh. do you have a workaround?@Gary Bushey