Getting data from multiple office 365 tenants

[DLGross]

How can I get user adoption data from multiple tenants, like what is done in the M365 Usage Adoption App but fore many tenants owned by the same organization?

[Red217]

When trying to do it with multiple tenants ( over 50 ) , i see the "permission" becomes an issue, it cant "remember" all.

i was trying to maybe set one "global reader" admin but it doesnt work 😞

some advice please 

[DAVZELL]

hello, have you find a solution to do this  ?

I try to use "Microsoft 365 Usage Analytics" template in PowerBi but with multiple tenants.

Microsoft 365 Usage Analytics connect only to one tenant by default.

[DLGross]

No, i have not found a way to do this. 

[v-easonf-msft · Accepted solution]

There, @DLGross

Not very clear.

For help, see this article to customize reports in Power BI Desktop:

https://docs.microsoft.com/en-us/microsoft-365/admin/usage-analytics/customize-reports?view=o365-wor...

You can connect directly to the Microsoft 365 ODATA reporting APIs that feed these reports.

You can then combine these data sources in Edit Queries.

Best regards
Community Support Team _ Eason
If this post helps,then please consider Accepting it as the solution to help the other members find it more quickly.