Forum Discussion
Office 365 Adoption error 'DataSource.Error: OData' and licensing user reporting
Hi there,
I'm having issues connecting the Office 365 Adoption to our tenant - using the
'Microsoft 365 Usage Analytics app.
When checking query editor, three of the queries are failing, one of which is the UserActivity which seems to be failing the reporting.
Error prompting below.
DataSource.Error: OData: A supported MIME type could not be found that matches the content type of the response. None of the supported type(s) 'application/json;odata.metadata=minimal;odata.streaming=true;IEEE754Compatible=false, application/json;odata.metadata=minimal;odata.streaming=true;IEEE754Compatible=true, application/json;odata.metadata=minimal;odata.streaming=true, application/json;odata.metadata=minimal;odata.streaming=false;IEEE754Compatible=false, application/json;odata.metadata=minimal;odata.streaming=false;IEEE754Compatible=true, application/json;odata.metadata=minimal;odata.streaming=false, application/json;odata.metadata=minimal;IEEE754Compatible=false, application/json;odata.metadata=minimal;IEEE754Compatible=true, application/json;odata.metadata=minimal, application/json;odata.metadata=full;odata.streaming=true;IEEE754Compatible=false, application/json;odata.metadata=full;odata.streaming=true;IEEE754Compatible=true, application/json;odata.metadata=full;odata.streaming=true, application/json;odata.metadata=full;odata.streaming=false;IEEE754Compatible=false, application/json;odata.metadata=full;odata.streaming=false;IEEE754Compatib...' matches the content type 'text/html; charset=utf-8'.
Details:
DataSourceKind=OData
DataSourcePath=https://reports.office.com/pbi/v1.0/**********/UserActivity
ie
Also, not sure if I need to post this separately, is there away of pulling in a user detailed licensing report with the adoption or Usage Analytics
Example
| DisplayName | UserPrincipalName | AccountSku | DYN365_CDS_O365_P2 | MICROSOFTBOOKINGS | KAIZALA_O365_P3 | MICROSOFT_SEARCH | WHITEBOARD_PLAN2 |
| User | User | [email protected] | ENTERPRISEPACK | PendingProvisioning | PendingProvisioning | Disabled | PendingProvisioning |
I'm able to gather the data using powershell and then import it into PowerBI. Not sure if there is an easier way to build ot automate the reporting as I'm still pretty new to this.
Many thanks.
Thanks Anonymous ,
Already followed the steps, the link that you provided is the public preview though, is there an updated or live version?
Getting the following.
TenantClientUsageOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.TenantMailboxUsageOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.TenantOfficeActivationOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.Many thanks.
2 Replies
Anonymous
Please make sure all required steps in this document are finished.
You can also try to download the PBI template file from here. Then follow the Use the Adoption content pack Power BI template section in this article to check if you can get data successfully in PBI Desktop. If yes, you can publish the report to PBI Service.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thanks Anonymous ,
Already followed the steps, the link that you provided is the public preview though, is there an updated or live version?
Getting the following.
TenantClientUsageOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.TenantMailboxUsageOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.TenantOfficeActivationOLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.Many thanks.