We have downloaded the Microsoft 365 usage report from the Power BI service workspace. Now the requirement is to add filters to the same report but while refreshing the data through Power BI desktop using OData we get some errors.
Not sure what it means, the Power BI report in the online also throwing the same error as below -
Last refresh failed: Wed May 11 2022 00:00:40 GMT+0530 (India Standard Time)
There was an error when processing the data in the dataset.Hide details
Processing 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'.
Cluster URI: WABI-NORTH-EUROPE-G-PRIMARY-redirect.analysis.windows.net
Activity ID: e5eeadd5-0c90-4621-910b-51ab5d4677d5
Request ID: 3b241033-5f7f-41d2-ad39-c37dff9114f4
Time: 2022-05-10 18:30:40Z
Please help!
