Error Message on Power BI Desktop: Web.Contents failed to get contents from _____ (502): Bad Gateway

[DMB90]

One of my API links is causing a Power BI error when loading and says the following: 

Web.Contents failed to get contents from [url] (502): Bad Gateway

When I downloaded the file, I noticed it's over 55,000 KB. Is there a way to resolve this? Will I potentially have to just download this data daily in order for the data to load properly? I'm not able to remove any of the data as it's critical.

[Ritaf1983 · Accepted solution]

Hi @DMB90 

The issue isn't with Power BI itself, but rather with the data source you're trying to access.

A 502 Bad Gateway typically indicates a problem on the source server’s side – for example, it may be overloaded or rejecting the request due to size or rate limits. Since you mentioned the file is over 55 MB, it’s possible that the API or server has limitations on request size or timeout thresholds.

If you can’t filter or reduce the data in Power BI, I recommend reaching out to the support team of the data provider to clarify:

• Are there any known limits on download size or request frequency?

• Is there a recommended way to paginate or query partial data?

• What’s the best way to handle large datasets through their API?

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[DMB90]

Thank you. I have reached out to the source support team.