PowerBI and Kobo in own server

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

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

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

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

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”: [
{

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

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

Did you manage to have this fixed?

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

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