Connected to box.com but getting Bad Gateway error

[eponkratova87]

I am pulling several reports from box.com. If I refresh from Power BI desktop, it is getting refreshed wo problem but then, if I try to refresh from the cloud, I am getting the Bad Gateway error. I've tried to play with the security settings, like Anonymous vs Organizational; Anonymous vs Public; Anonymous vs Private and still keep on getting the error. Interestingly, though, when I changed to  Anonymous vs Organizational, it refreshed but then, failed the next day with the same 502 error. What could be a solution?

Web.Contents failed to get contents from 'https://public.boxcloud.com/d/DChgPE2g1FmnH_HWYP_Rv4AzfoDr5ymYttRdBevje9-BHDkuR-cdtvMv3K6gBwGgRPsLBn...' (502): Bad Gateway
Cluster URI:	WABI-SOUTH-AFRICA-NORTH-A-PRIMARY-redirect.analysis.windows.net

[PhilipTreacy]

Hi @eponkratova87 

502 Bad Gateway is an error at the website/host, and can often be caused by a request taking too long to respond.  Your request may be starting something like a database query or a PHP script that is taking a long time to respond.

Are your refreshes taking a long time to respond before you get the 502?

Can you break the queries into smaller steps so not as much data is being requested per query?

Check with BoxCloud what their max execution time is for a web request or script execution.

Phil