Forum Discussion
MS Teams usage report
Hi have created a MS teams usage report using OData from the URL which was working a month ago. When I refresh the report now, I get the following error.
let
Source = OData.Feed("https://reports.office.com/pbi/v1.0/" & TenantID,null,[ODataVersion=4]),
TenantClientUsage_table = Source{[Name="TenantClientUsage",Signature="table"]}[Data]
in
TenantClientUsage_table
Error Details
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/4e789d73-039d-4360-bb8d-3c9b1ddb140f/TenantClientUsage.
Can someone help what is wrong and are there any changes made from Microsoft and possible fixes I can apply
The error happens because the Office 365 Reports OData endpoint (reports.office.com) is being deprecated or restricted by Microsoft. It now returns an HTML response instead of JSON which Power BI cannot process.
That’s why it worked earlier but fails now. Recent security and API changes block legacy or anonymous access causing Power BI to throw a MIME type error.
Fix is to switch to Microsoft Graph APIs for Teams usage reports, as they are officially supported, secure, and actively maintained by Microsoft.
Microsoft Documentation:
Microsoft Graph reports API overview - describes the reporting capabilities available through Microsoft Graph:
https://learn.microsoft.com/en-us/graph/reportroot-concept-overviewMicrosoft Graph Teams usage reports - example endpoint for retrieving Teams user activity via Graph:
https://learn.microsoft.com/en-us/graph/api/reportroot-getteamsuseractivityusercounts?view=graph-rest-1.0Working with Microsoft 365 usage reports in Microsoft Graph - guidance on usage reports with Graph:
https://learn.microsoft.com/en-us/graph/api/resources/report?view=graph-rest-1.0
3 Replies
The error happens because the Office 365 Reports OData endpoint (reports.office.com) is being deprecated or restricted by Microsoft. It now returns an HTML response instead of JSON which Power BI cannot process.
That’s why it worked earlier but fails now. Recent security and API changes block legacy or anonymous access causing Power BI to throw a MIME type error.
Fix is to switch to Microsoft Graph APIs for Teams usage reports, as they are officially supported, secure, and actively maintained by Microsoft.
Microsoft Documentation:
Microsoft Graph reports API overview - describes the reporting capabilities available through Microsoft Graph:
https://learn.microsoft.com/en-us/graph/reportroot-concept-overviewMicrosoft Graph Teams usage reports - example endpoint for retrieving Teams user activity via Graph:
https://learn.microsoft.com/en-us/graph/api/reportroot-getteamsuseractivityusercounts?view=graph-rest-1.0Working with Microsoft 365 usage reports in Microsoft Graph - guidance on usage reports with Graph:
https://learn.microsoft.com/en-us/graph/api/resources/report?view=graph-rest-1.0Hi ChaitanyaKarra
I wanted to check if you had the opportunity to review the information provided by krishnakanth240 . Please feel free to contact us if you have any further questions.
Thank you.May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
