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.
KoBo Power BI Connector.pbix (124 KB)