PowerBI and Kobo in own server

Kobo On Your Own Server
1

Dear, do anyone have made the integration with PowerBI and Kobo in own Server ??

Because when i try it every time ask me to give the password as it do not understand the connection.

Is something that i must change in the instructions ?

Thanks in advance
Pnaos

2

Hi Pnaos,
There could be a plethora of reasons of why this may not be working. I suggest that you detail the steps you took so that we can get to figure out what is the issue.
Stephane

3

OK perfect …
Step 0… Share publicly the form
Step1 … goto url http://kc.dock.xxxx:8585/api/v1/data
Step2. write down the url “http://kc.dock.xxx:8585/api/v1/data/9” from the following section

GET /api/v1/data
HTTP 200 OK
Allow: GET, POST, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept
{
“id”: 9,
“id_string”: “adRrStfMF7MjAsGUhd8ne2”,
“title”: “Excavation Form”,
“description”: “Excavation Form”,
“url”: “http://kc.dock.xxx:8585/api/v1/data/9”
}

Step3 … Open POWER BI Desktop (Version: 2.79.5768.721 64-bit (March 2020))

Step4… Download and Open [Power BI file] (https://drive.google.com/open?id=1kYUnVjXIU5zFK-Yn43dPqARy-3L8N7xr)

Step5… Select Get Data ----> Option Web and at Option Basic enter the URL
http://kc.dock.xxx:8585/api/v1/data?format=csv

Step6 … Press Refresh and ask for Credentials … in Option Basic enter userName (super_admin) and password (xxxx) and in Select which level to apply these setting to (http://kc.dock.xxx:8585/api/v1/data)

Step7… Error We couldn’t authenticate with the credentials provided. Please try again.

Thats all

Panos

4

Hi,
The best way to check is to post this url in full on a browser, http://kc.dock.xxx:8585/api/v1/data/9

If it opens without requiring a password, then it will work otherwise you need to have this sorted on your server for it to connect to PowerBI

5

It returns

Data List

This endpoint provides access to submitted data in JSON format. Where:

  • pk - the form unique identifier
  • dataid - submission data unique identifier
  • owner - username of the owner(user/organization) of the data point

**AND AFTER SOME LINES **
RETURNS ME THE RECORDS…

GET /api/v1/data/9
HTTP 200 OK
Allow: GET, POST, PATCH, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

[
{
“_notes”: [],
“group_general17/report_date”: “2015-04-30”,
“group_general10/stone_size”: “stone_size3 stone_size5”,
“group_general10/munsel_dscr”: “Yellowish brown, dark yellowish brown”,
“_bamboo_dataset_id”: “”,
“_tags”: [],
“group_general15”: [
{

6

Have you tried this process on our servers and it worked for you?

7

Finally last night i get it… with anonymous authentication direct access to data…

But today when i tried the same enter the url http://kc.dock.xxx:8585/api/v1/data/9 in the browser … i get a

### 500 Error

If this is a significant error that needs to be fixed, please send a support request to support@kobotoolbox.org with information about what triggered this error.

Any ideas… everything else works fine…

Panos

8

Did you manage to have this fixed?

9

Hi stephane

This one did not fixed … i cannot managed to fix the case of use api/v1 after a few calls with power bi

Right now after the answer from one of your other member i try to use kf… assets … submission to acces the submision with other way…

I will inform you about the results…

So regarding this issue i’ m not sure if you must close it… i will give it a try again.

Thanks
Panos

1 Like
10

Does everyone, know what service is responsible for the generation of records through this API
http://kc.dock.xxx:8585/api/v1/data/9

I’m trying to find why after some calls stops working…

At the other hand http://kf.dock.xxx:8585/assets/[hash of the form]/submissions/ works fine until now…

What’s the differences between two approaches ??

I tried both cases with MS POWER BI

Panos