404 Not Found Error when trying to connect Kobo to Power BI

Hello. I’ve spent multiple hours trying to connect a Kobo project to Power BI following the official documentation at Connecting Kobo to Power BI AND Synchronous Exports. Each time I try I get a 404 Not Found error.

I’ve looked at related Community Forum postings such as this, this, this and this.

@Kal_Lam or others - any assistance would be appreciated. Does the official documentation only work if making data public, which is not an option at all for this project? I’ve found some workarounds with JSON, but just trying to understand this better. Thank you!

Hi @Adaptation_Forest,

Maybe I can be of help. I wrote one of the posts you were referring to. At first we were also unable to solve Kobo - Power BI connection issues but we were able to get a support contract and also reached out to the tech people at the World Bank. Together they pointed us in the right direction.

I’m now on my way to the office, once I’m there I can copy paste some of the information that we received per mail. Maybe this is already of help to you.

Could you provide us with some more information on the number of submissions and in what format you would like to download the data?



1 Like

Many thanks Neil! I don’t have a strong preference on format for data download (as far as I know) as long as it supports the full range of Power BI functionality. It’s a new project so less than a thousand submissions currently. In an ideal world (i.e. if program continues/grows), submissions could grow into the tens of thousands.

Ok, let’s start with the simple solution first.

We don’t use the synchronous exports because it has a timeout of 120 seconds. At that time, even with ‘only’ 12k submissions or so we faced timeouts.

We (still) use the V2 JSON API and have over 66k submissons. Downloading the data should be pretty straight forward. In Power BI select get data and pick web. Then paste the URL below.


You of course need to change ‘yourassetuidhere’ in the URL above for your own unique asset ID. In case you don’t already know how to find it: Connecting to your data using synchronous exports — KoboToolbox documentation

Maybe you can share the results of this action? Do you still get a 404? If so, straight or only after a while?



Thanks Neil! I’m now having success connecting with your instructions, as well as with this JSON format: https://kobo.humanitarianresponse.info/assets/[UUID]/submissions/?format=json
I’m also now able to connect using the Kobo documentation and Synchronous Exports.
The error I was making (apparently) is that, since I haven’t made my data public, I always need to connect to Web via the Advanced (rather than Basic) option and always add my API token in the HTTP Request Header Parameters per below.

I think the Kobo documentation could benefit from more clearly spelling out this requirement here: Add the Data Source.

That’s great to hear that you are able to utilize your JSON format with the large number of submissions you have! Promising news for my own purposes!

Many thanks,