Pull data from Kobo to Power BI

[Kal_Lam]

Hi @scherrie,

Would you mind having a look at the post discussed previously, it should help you solve your issue:

Connecting Power BI to KoBo

The easiest way to connect Microsoft Power BI and view all non-public datasets in KoBo is by Step 1: Connecting to the following web url (https://kc.humanitarianresponse.info/api/v1/data?format=csv) then entering your KoBo username and password.You will receive a CSV file with a directory of all your datasets and their respective URL. [image] **Step 2: **Copy the URL of the dataset you need to connect to then add it again as a new Web source. [image] You can alternatively use the attached …

And this discussion should also help you out:

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…

And also this post discussed previously:

Kobo to Power BI - securely via API

I’ve been able to use the new kpi API to connect Kobo securely to Power BI and read submission results. I thought this might be of interest to others or could be improved on, so I’m sharing my steps below: WRT http://support.kobotoolbox.org/en/articles/592398-api-and-rest-services , get your API token Get your Form uid - e.g. visit your Project in kobotoolbox and it is embedded in the URL, between “/forms/” and “/summary” Construct the URL e.g. in Notepad, following the form: https://[kpi-url…

Have a great day!