Office 365 Application Usage in Power BI

[kris_vin]

Hi, 

We are trying to build a Power BI dashboard that shows the user activities in the Office 365 Applications. Below are the few examples of, what type of report we are trying to get. 

--> List of users accessed applications after office hours

--> List of users email communication after office hours

--> Users email activities 

--> Application usage

We tried using Office 365 Admin usage report in Power BI but, we are not able to get all the data we are looking for. Is there any other way we can connect to the usage data from Power BI?  Also, we understood that it will take more than 24 hours to update the activities in the usage report. 

Any advice will be appreciated. 

Thanks,

[v-jayw-msft]

Hi @kris_vin ,

You might use Power BI REST APIs.

https://docs.microsoft.com/en-us/rest/api/power-bi/

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[kris_vin]

Thanks for the reply @v-jayw-msft . 

Could you please give us some more details? How do we access the email activities with the date and time from Exchange? If you could provide a few more details. that will be really helpful.

Appreciate your help 

Thank you