Newbie question - Custom connector for O365

[Anonymous]

Hello, 

I apologize in advance for the very basic question, but I've been tasked to find out how I can create a custom connector for Power BI that connects to Office 365 and retrieves usage data. 

I have seen some reporting solutions that are based on PowerShell calls. Other people told me that the only way of doing that is via Graph, which seems quite complicated.

Can someone roughly explain to me how that would work? Any links are appreciated. 

Thanks

[Greg_Deckler]

@Anonymous - Have you reviewed this? Microsoft 365 usage analytics - Microsoft 365 admin | Microsoft Docs. It indicates that there is a PBIT available where you can use Power BI Desktop with the usage analytics.

Also this: Customize the reports in Microsoft 365 usage analytics - Microsoft 365 admin | Microsoft Docs

[Anonymous]

Hi Greg, 

Yes, I'm familiar with the Usage Analytics and the CQD Connector for Teams. I need an alternative as they both have several limitations and performance issues. 

Thanks! 

[Anonymous · Accepted solution]

HI @Anonymous,

Unfortunately, office 365 seems not to provide other methods to get data except graph API. For this scenario, you may have to use the corresponding API to get data. 

Notice: if your custom connector is designed based on the API, it also shared the limitations which raw API listed.

Regards,

Xiaoxin Sheng

[Anonymous]

Thank you for the clarification...