topic Scheduled Refresh failed for Microsoft Defender API report in Developer

Scheduled Refresh failed for Microsoft Defender API report

mheagerty — Wed, 01 Feb 2023 01:52:36 GMT

Hi, I have downloaded Power BI template 'vulnerabilities_report_V6_full_dataset.pbit' from GitHub repository as follows:

https://github.com/microsoft/MicrosoftDefenderForEndpoint-PowerBI/tree/master/TVM/TVM%20report%20templates%20June%202021

I would like to create a seperate report for each of the tenants that I manage, but connect to them all from my primary tenant.

To acheive this, I have tried to modify the Data Source settings from this template to use 'Anonymous' authentication.
This connects to the Odata source(es) using the Application ID, TenantGUID, and ApplicationSecret configured when creating the App registration/ connectivity to the Microsoft Defender API.

This works fine when I connect /refresh the data in Power BI Desktop, however the published report fails to refresh data with the following error:

Hoping someone can help resolve this issue

Kind Regards

Mike

Re: Scheduled Refresh failed for Microsoft Defender API report

Anonymous — Fri, 10 Feb 2023 09:35:26 GMT

Hi @mheagerty ,

According to the error message, it seems that privacy level setting cause the error. Did you involve multiple data sources in the report? Please review this official documentation and check if it be set the proper privacy level for every data source.

Best Regards

Re: Scheduled Refresh failed for Microsoft Defender API report

fvhr9190 — Mon, 05 May 2025 12:24:19 GMT

Did you find a solution for this? It's possible to connect to the application, but the data is not in the correct OData format.