Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
mheagerty
Frequent Visitor

Scheduled Refresh failed for Microsoft Defender API report

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%20tem...

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.

mheagerty_0-1675215850901.png

 

mheagerty_1-1675215965540.pngmheagerty_2-1675215996854.png

 

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:

mheagerty_3-1675216228519.png


Hoping someone can help resolve this issue

Kind Regards

 

Mike

2 REPLIES 2
fvhr9190
New Member

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.

Anonymous
Not applicable

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.

yingyinr_0-1676021592694.png

Best Regards

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.