Whenever I try refreshing my Power BI Dashboard which the connection is via API from Kobo Server to Power BI Server I get error 502 Bad Gateway, below is username, project name, server and screenshot.
Project name: Harmonized Protection Monitoring Tool Household Assessment (HHA)
@baana2005, this post discussed previously should help you solve your issue:
Hi Please try this one, You need to give the correct username and password or API key.
Previously I am using this URL ‘https://eu.kobotoolbox.org/assets/aEgHKW9Xs6vH2sThaGVUuB/submissions/?format=json’
before @Kal_Lam suggested a post which indicated that I should use URL https://kc-eu.kobotoolbox.org/assets/aEgHKW9Xs6vH2sThaGVUuB/submissions/?format=json
but is given me 404 error and you suggested I should use URL https://eu.kobotoolbox.org/assets/aEgHKW9Xs6vH2sThaGVUuB/submissions.json
but same error which is 502 Bad Gateway I’m getting before I posted this post, see screenshot
I’m also attaching screenshot of the Advance Editor
I will appreciate if this my issue being resolve,
Hi Again, I am quite confident that the link is working, I think the problem is from your side not the link side. Can you share with me how to you pass the login credentials? Are you using username and password? using API key?
Kindly find below how I connected the Kobo server to Power BI using authentication,
Your method is correct, The only option is either your token code is wrong, or there is something wrong with your form ID. Those are the options i can recall for now
The Token is correct because I just checked it and also the Form ID is correct, see below the form ID
can you just copy the link to the browser and see the result? if it is working it should show the data, else should be return empty page
Dear @osmanburcu @Kal_Lam,
Kindly note that I was able to refresh the data by right click on single refresh from the panel, I observed that due to the duplication of the main form up to 47 in number which previously I used to refresh all at one and encounter the error but refreshing one by one is working, see screenshot below.
instead of clicking refresh one by one, You can disable the refresh for the table that causing the problem. While you are in power query, right click your data set and untick the include in report refresh so next time when you click the refresh button, it will refresh all data sets except this disabled one
Thank you for the suggestion but all the table I need them to be refresh because they consist useful data and that’s why I duplicated the main data to be able to do split and pivot column which if I do from the main data is adding the main information so I have no choice rather that duplicate the particular question and the analysis. I will appreciate if you have more suggestion apart from this one which will refresh all without getting error.
Dear @baana2005 ,
The bad gateway error response still persists.
Dear @tomisin ,
What I said is you need to refresh one by one to pass the error, myself I’m getting the error when I click on refresh all but when I do one by one I successfully refresh, save and publish my work in power BI,
If anyone know another alternative apart from refreshing one by one the person should inform us please. Thank you all