Power BI error message: The downloaded data is HTML, which isn't the expected type

Issue symptoms

After connecting Zendesk to Microsoft Power BI, this error message appears: The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server.

Resolution steps

To resolve this error, follow the steps below:

1. Call the Global OAuth Clients endpoint and get a list of the clients.If the client shows ID 131, you are using the previous Power BI connect made by Microsoft, rather than the connector from Zendesk.
2. List the tokens under the Zendesk profile, used to install the connector. A call to the previous client would look like this:

   

3. Revoke the token using the value from the ID attribute. This will allow Power BI to request a new token from the Zendesk connector.
4. Once the connection has been cleared, install the Power BI Connector by Zendesk (Beta).

Disclaimer: Zendesk doesn't provide support for Power BI. See the Microsoft documentation if you need assistance.