PBI and Office 365 datasets

[Jeallo83]

How can I connect to my office 365 live data so I can build pbi reports off of how many emails are received/sent ect vs how many teams messages are sent.

[Anonymous]

Hi, @Jeallo83 

Please check out the link below and I hope it helps.

About Microsoft 365 usage analytics - Microsoft 365 admin | Microsoft Learn

Connect to Office365Mon with Power BI - Power BI | Microsoft Learn

Customize the reports in Microsoft 365 usage analytics - Microsoft 365 admin | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jeallo83]

This is what I get when I try to use option 2 and connect my data. How do I fix this? I am an admin in my tenant.

[Anonymous]

Hi, @Jeallo83 

The error message "lacks a service principal" is displayed, or you need to configure a service principal first.

Embed Power BI content in an embedded analytics application with service principal and an applicatio...

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jeallo83]

[Jeallo83]

I'm sorry, I dont know what you mean by this. How do I find the data source?

[GilbertQ]

Hi @Jeallo83 

You will need to find the data sources for the emails, all the teams which you can find by searching the Internet. Once you find those sorted, you can then use power BI to connect to them.