KoBoToolbox

Note: These instructions require your data to be publicly accessible so PowerBI can pull it without needing to authenticate with the KoBo server. Unless you are comfortable with sharing all your data publicly do NOT use this option. 

  1. From your project's Setting tab, click on the slider to set "Share Data Publicly" to "Yes."
  2. Click on "Save Changes"

PowerBI

  1. Open the Power BI file 
  2. Click on Edit Queries found under the Home ribbon

3. Click on Edit Credentials    

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


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.


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

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

Did this answer your question?