Daily O365 Usage Metrics

[Anonymous]

Hello All,

My first post! I need to build a report/dashboard of my tenants O365 product usage. So exactly the reports that you can view in the Admin Centre, but how can I get that data into PBI?

[lbendlin]

Take the audit reports, stuff them into dataflows, and then consume them with Power BI. There may even be a template somewhere that already gives you some visualization starters.

[Anonymous]

Thanks so much for the response, that's a helpful pointer. Do you know if the Admin Centre Usage Reports would be accessible from the (?) Common Data Model. Its getting hold of the source data that is my challenge, so far the only way I can find is to manually log in to the admin centre and export the reports I need, and save the files.