Forum Discussion
Advanced Hunting API fails for DeviceTvmSoftwareVulnerabilities table
I am having the exact same issue with the API call using https://docs.microsoft.com/en-us/microsoft-365/security/defender/advanced-hunting-devicetvmsoftwarevulnerabilities-table?view=o365-worldwide
I have a number of PowerBI report which are now failing with a (400): Bad Request DataSource.Error: Web.Contents failed to get contents from 'https://api.securitycenter.microsoft.com/api/advancedqueries.
The report had been working fine since they were created about 6 months ago and started failing late December.
I have recreated the Query with a very basic lookup but anything from DeviceTvmSoftwareVulnerabilities fails. All other queries to any other Schema works fine and using the DeviceTvmSoftwareVulnerabilities schema direct from Advanced Hunting works fine so something must have changed with the API.
- This appears to be fixed, although MS didn't say they had done anything.
I can confirm this is fixed on my end now as well. So I suspect it was an issue on their end that they have resolved.
- I've logged a ticket with MS Support and they have escalated internally. Will try to remember to post back here if/when it is resolved.
