Forum Discussion
Connect to your data with Usage Analytics
I was following this instruction as below:
At step 2, I got this error message after entering our Tenant ID:
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'.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'.
That error basically means Power BI expected an OData/JSON response, but the URL it’s calling is returning an HTML page instead. In this Microsoft 365 Usage Analytics flow, that almost always happens when the request gets redirected to a sign-in page, blocked/denied, or you’re not actually subscribed/ready for the Usage Analytics dataset yet, so the service returns an HTML message page rather than the OData payload.
If your org uses Conditional Access or MFA, that can also lead to HTML being returned to the connector. This is why the account you are using needs to have the Usage Summary Reports Reader role. Also because of the least privileged roles by task principle you should apply.
8 Replies
Hi pt3thanh285, it could be that your usage analytics is still not ready. Check the page Enable Microsoft 365 usage analytics where you can read that it can take up to 48 hours depending on the size of your tenant. The Go to Power BI button is enabled (no longer gray) when data collection is complete.
And, you need to make sure your account has the required admin/reader roles for Usage Analytics. This would the Usage Summary Reports Reader role. The role should permantly assigned to your account to be able to schedule the semantic model refresh.
Hope this helps. If so, please give kudos 👍 and mark as Accepted Solution ✔️ to help others.
it is def not the case. I activated the report feature a week ago. Also the account has admin role. Doesn't affect anything. Also its not what the error was about
That error basically means Power BI expected an OData/JSON response, but the URL it’s calling is returning an HTML page instead. In this Microsoft 365 Usage Analytics flow, that almost always happens when the request gets redirected to a sign-in page, blocked/denied, or you’re not actually subscribed/ready for the Usage Analytics dataset yet, so the service returns an HTML message page rather than the OData payload.
If your org uses Conditional Access or MFA, that can also lead to HTML being returned to the connector. This is why the account you are using needs to have the Usage Summary Reports Reader role. Also because of the least privileged roles by task principle you should apply.
Hi,
Power BI is expecting JSON from the usage analytics OData endpoint, but the service is returning an HTML page instead (for example a sign-in or error page), so you get the “supported MIME type could not be found / text/html” message.
A few things to double-check:
- In the Microsoft 365 admin center, under Reports -> Usage, make sure “Make organizational usage data available to Microsoft usage analytics for Power BI” is turned on, and that it has been enabled for at least 24 hours.
- Confirm that your tenant is really GCC (these steps do not work for GCC High / DoD or normal commercial tenants).
- When the template asks for credentials, choose Organizational account / OAuth2 and sign in with a Global admin for that tenant.
If all of that looks correct and the error is still there, try opening the URL from one of the failing queries in a browser while logged in with the same account. If you see an HTML error page instead of JSON, it is likely a service/tenant issue and you will probably need to open a ticket with Microsoft 365 support.
I don't think you need to have a global admin account to load the data. only to enable the data analysis feature for reports.
Yes, that's true.
Hi pt3thanh285,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to nielsvdc,IrinaTokm, for those inputs on this threa
Has your issue been resolved? If the response provided by the community member nielsvdc,IrinaTokm, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.Hi pt3thanh285,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.
