Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

M365 Defender Advanced Hunting export DeviceTvmSoftwareVulnerabilitiesKB to Power BI

I am trying to export the DeviceTvmSoftwareVulnerabilitiesKB table from the M365 Defender Advanced Hunting page to Power BI. I am using the query provided here and setting "AdvancedHuntingQuery" to "DeviceTvmSoftwareVulnerabilitiesKB".

 

This works perfectly when I query for "DeviceTvmSoftwareVulnerabilities", but not for "DeviceTvmSoftwareVulnerabilitiesKB". Can anyone explain why this is?

 

I'm posting this in the M365 Security section because, given the query works for one table and not the other, I believe it is a problem with the M365 Defender API rather than with Power BI. However it could be a PBI issue.

Need Help

3 Replies

  • nkoapentocom's avatar
    nkoapentocom
    New Member
    5 years ago

    I have difficulties when I query for "DeviceTvmSoftwareVulnerabilities", even when I use the query you provided. How do you get this to work? 🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Wish I could help you, but I don't know. I just copy/pasted the query exactly as it is into the PBI Advanced Editor, then set "AdvancedHuntingQuery" equal to "DeviceTvmSoftwareVulnerabilities". No issues at all.