Forum Discussion
AxelHellstroem
Jul 15, 2022Copper Contributor
Defender for Endpoint - PowerBI report
Hello! I'm currently developing multiple PowerBI reports for Defender for Endpoint where we utilize the advanced hunting query API described in this article here: https://techcommunity.microsoft.com...
- Aug 23, 2022I wrote an article on this. If you find any issues following let me know.
https://medium.com/@kaustubh.dwivedi/create-custom-reports-using-power-bi-for-a-multi-tenant-scenario-571de6e756b0
AxelHellstroem
Aug 23, 2022Copper Contributor
Incredible, thank you so much for writing this article.
Will test this out ASAP.
Will test this out ASAP.
Kausd
Microsoft
Aug 23, 2022If you do face issues let me know would love to help you out.
- AxelHellstroemAug 23, 2022Copper ContributorThis works really great. Only one thing should be added:
The (main) function should be named RunAHQuery in order for the queries to work with the function. Otherwise - this is a very good guide on how to work with BI & App registration.
Thank you so much for providing this.- KausdAug 24, 2022
Microsoft
Thanks can you clarify the RunAHQuery issues ? I am bit confused 🙂- AxelHellstroemAug 25, 2022Copper Contributor
The main query / function created in step 1 should be named "RunAHQuery".
Is there anyway I can reach out to you by teams or email to explain this a bit more?
Thought it could be a nice extension to your article:
This function can also be utilized to access the security graph API with client secret, which enables you to run advanced hunting queries on all Defender for M365 products 🙂