Cross tenant Defender API to PowerBI

Berghegen, Nick 20 Reputation points


As the title says, i am looking for a way to combine MS Defender API information from multiple tenants into 1 PowerBI table.

I can query this with my user account for 1 tenant but i want to query it for multiple tenants in 1 click.

Can someone advise me how to approach this. Maybe by using a service principal or multi tentant Azure APP?

Thanks in advance!


Microsoft Defender for Cloud
Microsoft Defender for Cloud
An Azure service that provides threat protection for workloads running in Azure, on-premises, and in other clouds. Previously known as Azure Security Center and Azure Defender.
1,211 questions
Microsoft Defender for Identity
Microsoft Defender for Identity
A Microsoft service that helps protect enterprise hybrid environments from multiple types of advanced, targeted cyberattacks and insider threats.
158 questions
0 comments No comments
{count} votes

Accepted answer
  1. Shweta Mathur 28,021 Reputation points Microsoft Employee

    Hi @Berghegen, Nick ,

    Thanks for reaching out.

    I understand you are looking to combine data from multi-tenant in Microsoft 365 defender to manage at one place for security reasons.

    You can register an application in Microsoft Entra as multi-tenant application and call Microsoft Defender API in each tenant to collect data from each of the tenants and report that to PowerBI table as well. However, combining Microsoft Defender API information from multiple tenants into a single Power BI table can be a complex task, as it involves integrating data from various sources and dealing with authentication issues.

    Alternatively, Microsoft 365 defender provides you to directly manage "multi-tenant management in Microsoft 365 Defender" which allows a unified view of all the tenants you manage which helps to streamline threats due to security reasons in single window.

    Reference -

    Set up multi-tenant management -

    Hope this will help.



    Please remember to "Accept Answer" if answer helped you.

    0 comments No comments

0 additional answers

Sort by: Most helpful