Access O365 Adoption Content Pack API Programatically

[bhushangawale]

Been exploring the recently released (public preview) Office 365 Adoption Content Pack and seems quite impressive, for sure!

Is it possible to connect programatically to the API i.e. https://reports.office.com/pbi/v1.0/<tenantid> which actually powers up this content pack ? 

[Anonymous]

The solution provided results in errors that are mentioned by several users at https://community.powerbi.com/t5/Desktop/O365-Content-OData-errors/m-p/197721/highlight/true#M86995.

A supported MIME type could not be found that matches the content type of the response. None of the supported type(s)

Can you please provide further support for this feature and allow a data connection through PBI Desktop?

Thank you

[v-qiuyu-msft · Accepted solution]

Hi @bhushangawale,

Office 365 Adoption Content Pack utilize the Graph reporting APIs which can be accessed at https://reports.office.com/pbi/v1.0/<tenantid> . See: Office 365 adoption content pack data model.

To call this API in Power BI desktop, you can use OData Feed data source. It will return data below, for more information, see Customizing the reports in Power BI Desktop section in this article.

Best Regards,
Qiuyun Yu

[Red217]

Hello, 

how can i access this via a "secretd ID & Secret Key" , asking becasue i want to use it for about 100 diffrent tenants and the "Organization Account" cant support it in PBI