O365 Adoption Pack OData error

[Nilsoo]

Hey,

I need to join data from the O365 adoption Pack with other data. According this article (https://support.office.com/en-us/article/Customize-the-Office-365-Adoption-Content-Pack-9b76065f-29b...) it should work. However, when connecting trough OData I receive these error messages. 

Any ideas how to solve this?


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/45822621-0c35-4772-b610-0387c186eeba/TenantOneDriveUsage

Thanks in advance.

[MartinK]

@Nilsoo I have the same Issue, if i try to open Connection, as it is described from Microsoft here:

https://docs.microsoft.com/en-us/office365/admin/usage-analytics/customize-reports?view=o365-worldwi...

I am able to login and get the Tables, but I  get the error when I select a table.

I tried both options, by the way. Reporting AIP and directly from the report template Microsoft 365 Usage Analytics.pbit 

@v-huizhn-msft The other thread does not help, because there is no solution an @Anonymous wrotes.

Thanks for help

Martin

[v-huizhn-msft]

Hi @Nilsoo,

ODataLib uses the Content-Type header to determine which format the response should be parsed as. The MIME type is not a valid content type per OData, which is why you're getting the error. And there is a similar thread, please review it.

Best Regards,
Angelia