Connecting Power BI to KoBo

[Chris Habib]

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. 

Step 2: Copy the URL of the dataset you need to connect to then add it again as a new Web source.

You can alternatively use the attached BI file to skip Step 1 - it will only prompt you to enter your username and password once when you access the query editor.

 

[Hanan Aqilan]

Hello

Thanks for this nice blog. What if i need to connect to the file with codes replaced or choices replaced by english label. Is there a way to do so please. Because right now I only get to connect to the codes not labels. 

Thanks, -Hanna

[Shannon L]

Hi Chris! Thanks for this - it appears really straightforward. Question for you - are there settings that you need to change in Kobo prior to the connection being active? I keep getting the message that "we couldn't authenticate with the credentials provided" - as are my colleagues (all with different account names). Any advice?

Thanks!

Shannon

[Chris Habib]

Hi Shannon, yes you do need to change your data sharing setting to "Public". Also please find attached the updated version of the converter that links to KoBo to retrieve data labels rather than names. Make sure you read the readme file with it :) P.S: if you are using a different KoBo instance of humanitarianresponse.info then you will need to change the link manually

[Loay Alsayed Mohammed]

Hi Chris,
after publishing the report on the web, and if there were new inputs. is there is any way to update the puplished dashboard automatically according to inputs

[Dan Kaigua]

Hi Chris,

I am using the KoBo to Power BI Connector v2. Getting the error below after I enter my credentials. Anyone who can assist, I would greatly appreciate. Thanks.

[Meredith Mahachi]

HI chris, 

Hoping you can help we are trying to connect, have followed all the steps but receiving error from power bi:

Details: "The credentials provided cannot be used for the Web source. Please update the credential type through a refresh or in the Data Source Settings dialog to continue. (Source at https://kf.kobotoolbox.org/.)"

I only used the base url https://kf.kobotoolbox.org do I need to grab more? 

Many thanks,

Meredith

[Meredith Mahachi]

HI Dan - I am also having this error now

[Meredith Mahachi]

@dan did you ever find a solution to the JSON error? 

On Sunday, May 20, 2018 at 9:53:28 AM UTC-4, Dan Kaigua wrote:

[Chris Habib]

Hi everyone, sorry been missing in action :) what KoBo platform are you registered on Meredith/Dan?

[Meredith Mahachi]

https://kf.kobotoolbox.org 

[Meredith Mahachi]

Now I was finally able to connect but the file is not converting as clean when I use the web connection vs having the CSV downloaded. I've set all the same parameters as the CSV import. encoding, columns, delimiter but it ends up looking ugly when it comes through the web query, it will ahve extra characters on the header or compress everything into one column.

On Wednesday, June 13, 2018 at 11:12:18 PM UTC-4, Chris Habib wrote:

[Mario Bastande]

Thanks to Chris Habib, it is very useful.

Regarding the permissions to share it publicly, if we are private organizations and we do not want our data to be public, does mean there is no way to access those data by this method? in that case, what other methods to use?

And second, when it comes to reading image URLs inside our survey, how do get that on PowerBI? I can only access the name.jpg field so impossible to display the image itself. 

Thanks!