Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 | User@test.com | 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.
Solved! Go to Solution.
Thanks @V-pazhen-msft ,
Already followed the steps, the link that you provided is the public preview though, is there an updated or live version?
Getting the following.
Many thanks.
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 @V-pazhen-msft ,
Already followed the steps, the link that you provided is the public preview though, is there an updated or live version?
Getting the following.
Many thanks.