Anyone Using new Manage.Office.Com REST API with PowerBI?

[Evogelpohl]

I'm interested in connecting PowerBI.com (Desktop or Excel via PowerQuery) to the new Office 365 Manage API - REST API here: https://msdn.microsoft.com/en-us/library/mt227394.aspx

I'd like to be able to query Office 365 Audit Log data & service health data for a "Office 365 Usage Dashboard" I'm envisioning.

Curious, before I spend the time registering all the app permissions; I'd like to know if anyone has had success connecting to this service & retreived data abour your O365 tenant from within PowerBI / Excel-PowerQuery.

Thanks.

Eric.

[tom_cowling]

https://docs.microsoft.com/en-us/power-bi/service-connect-to-office365mon

[bdarbonneau]

See this blog written by Prathy Kamasani
POWERBI AUDIT LOG USING OFFICE365 MANAGEMENT API