Forum Discussion
Connect to your data with Usage Analytics
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.
