Medium severitydata source
Power BI Refresh Error:
OData: The response is not a valid OData feed or service document
What does this error mean?
The OData connector received a response from the endpoint that is not valid OData XML or JSON. This usually means the API returned an HTML error page, a redirect, or an authentication challenge instead of data.
Common causes
- 1The OData endpoint URL has changed or been deprecated
- 2The API returned an HTML error page (404, 500) instead of OData content
- 3An authentication token expired and the API responded with a 401 or a login redirect page
- 4A proxy or load balancer intercepted the request and returned its own error page
- 5The API version in the URL is no longer supported by the service
How to fix it
- 1Paste the OData URL into a browser or Postman to see exactly what response the endpoint returns
- 2Check whether the endpoint URL requires an updated API version (e.g., v1 → v2 in the URL path)
- 3Re-authenticate: in Power BI Service, navigate to the dataset's data source credentials and re-enter or re-authorize
- 4If the endpoint returns a 301/302 redirect, update the URL in Power BI Desktop to the final destination
- 5Check with the API provider if the endpoint has been deprecated or moved