Pulling your data into PowerBI

KoBoToolbox

First, you need to find the unique URL that allows you to access your project data via the API. If you already know how to find this, skip to the next section.

  1. The unique URL has the following structure: https://[kobocat-URL]/api/v1/data/[unique-kc-ID].

  2. To find this URL, go to https://[kobocat-URL/api/v1/data/ and find the project in the list at the bottom, the. copy the value for ‘url’ (without the quotation marks). For example:

    image

PowerBI

image

  1. Open the Power BI file

  2. Click on Edit Queries found under the Home ribbon

    image

  3. Click on Edit Credentials

    image

  4. Under the Basic tab, enter your KoBo username and password then click connect

    image

  5. A table should load showing you all available forms which you have enabled data sharing in your KoBoToolbox account in addition to the languages (labels) you have designed them in. To connect to any of your forms’ data, copy the CSV link found under the CSV column.

    image

  6. Copy the URL of the dataset you need to connect to, then add it again as a new Web source.

    image

Thanks to Chris Habib for writing the initial draft of this post.