Forum Discussion

Pranoti98's avatar
Pranoti98
Frequent Visitor
11 months ago
Solved

refresh error :Web.Contents failed to get contents... (502): Bad Gateway

I've been using Power BI to connect to data collected via the KoBoToolbox API (https://kf.kobotoolbox.org). Everything was working smoothly until recently, when I started facing persistent refresh fa...
Need Help
  • Anonymous's avatar
    Anonymous
    11 months ago

    Hi Pranoti98 ,

    Thank you for reaching out to the Microsoft fabric community forum. Thank you amitchandak and rohit1991  for your response.

     

    You don’t have to rebuild your report. Keep all visuals and measures. Just change the source so the API data is first saved to a stable location (SharePoint, OneDrive, Dataverse, Azure, etc.) and then connect Power BI to that stored file/table. This avoids throttling and gives reliable refresh.
    Also let me know as amitchandak mentioned have you raised the issue in issues forum?

     

    Thank you.

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
11 months ago

Hii Pranoti98 

 

Your Power BI configuration is fine  the refresh failure is happening because KoBoToolbox is timing out or throttling large requests, which causes these 502 errors. Splitting the data into smaller chunks plus retry logic is the most reliable fix. If the KoBo API keeps returning 502, the only stable workaround is: don’t connect Power BI directly >> store the API data somewhere reliable >> refresh from that source.

  • Pranoti98's avatar
    Pranoti98
    Frequent Visitor
    11 months ago

    Hey Rohit,
    Thanks for your reply.
    thing is that i am working on this dahsboard since last 2 months, and i am worried if i do saves data to cloude/sharepoint and then access it from there, i need to do everything from start. 

    Thanks