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.
···
On Saturday, 23 September 2017 18:47:50 UTC+3, Chris Habib wrote:
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
On Friday, September 22, 2017 at 1:12:05 PM UTC+3, Shannon L wrote:
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
On Wednesday, February 1, 2017 at 5:12:06 PM UTC+3, Chris Habib wrote:
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.
