Pull data from Kobo to Power BI

[stephanealoo]

Hi @imad1
Welcome to the community forum. Could you please have a look at the topic that has been discussed below and see if it resolves your issue?

Kobo toolbox json api

The kobo json api is very not very clear and I understand people might be struggling to use in with their applications. After months of struggling and a lot of guess work i decided to write what I have been able to achieve. Before you continue I cannot guarantee that it works for everyone. Also I have a self hosted instance of kobo so the url and requirements might be different. Getting ready I am assuming that you have your kobo instance set up so I will not go over that part. If you ha…

Simple Connector for Power BI (Excel Power Query) to get labels from Kobotoolbox Data

Hi all, I have created a Power BI Template that connects a KoboToolbox Form to Power BI in a simple way. I think that it is simpler waythat the one HERE, I never managed to make it work…Like others I always got a Json Problem) The file is HERE It will get you the data with LABEL (Human Readable) in the DEFAULT language of your form. The data needs to be public for this to work. Thus you need to go to your form and go to SETTINGS–>SHARING [image] Select: Anyone can view submissions made to…

Stephane