Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Newbie question - Custom connector for O365

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

  • Anonymous's avatar
    Anonymous
    5 years ago

    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

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      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's avatar
        Anonymous
        Not applicable

        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