topic Re: Newbie question - Custom connector for O365 in Developer

Newbie question - Custom connector for O365

Anonymous — Wed, 16 Dec 2020 19:04:27 GMT

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

Re: Newbie question - Custom connector for O365

Greg_Deckler — Wed, 16 Dec 2020 19:35:21 GMT

@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

Re: Newbie question - Custom connector for O365

Anonymous — Wed, 16 Dec 2020 19:38:53 GMT

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!

Re: Newbie question - Custom connector for O365

Anonymous — Fri, 01 Jan 2021 02:45:21 GMT

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

Re: Newbie question - Custom connector for O365

Anonymous — Wed, 06 Jan 2021 14:40:19 GMT

Thank you for the clarification...