Forum Discussion
Getting data from multiple office 365 tenants
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?
There, @DLGross
Not very clear.
For help, see this article to customize reports in Power BI Desktop:
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.
5 Replies
- v-easonf-msft
Community Support
There, @DLGross
Not very clear.
For help, see this article to customize reports in Power BI Desktop:
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. 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.
No, i have not found a way to do this.
Red217Helper III
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
To get data from multiple Office 365 tenants or combine two Office 365 tenants, it can be done manually by exporting and importing data, but these methods are often error-prone and cumbersome. They can result in data loss and misconfigurations. To avoid these pitfalls, use the Sysinfo Office 365 Backup Tool, which streamlines the migration process. This tool guarantees data integrity and maintains folder structure, making the transfer of emails, contacts, and calendars between tenants hassle-free and secure.
