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.