Connecting KoBoToolbox data with Power Bi (without making data public)

[j_fog]

Hi everyone! I am trying to connect kobo to Power BI using the aforementioned steps above, but I keep getting this error message:

Can anyone please advice me? I have tried to reset the privacy settings but with no luck…

Thanks in advance for any help!

[Kal_Lam]

@j_fog, have you gone through this post discussed previously (it should help you solve your issue):

Automatic updates in PowerBI Pro from files linked to KOBO

Dear, I am developping a few dashboards on my PowerBI Pro that import data from KOBO toolbox and Excel (Onedrive). As my teams on the ground send in regularly new data I would like the dashboards to update at least every day once, for now I do it manually but I want to automatize it. I found a few links on the web that guide me how to do it but it didnt work out and honestly it seems quiet complicated for a non IT person. I didnt found any topic on this community so decided to ask here. Any …

Please also feel free to go through our support article Pulling Data Into PowerBI.

[j_fog]

Thank you so much for getting back to me @Kal_Lam !

Yes, well I originally did the API connection above (which was a bit tedious not going to lie). Then I did it the “?format=csv”-way (which you have linked) and it worked well for displaying the kobo project dashboard. However, I am trying to extract data from kobo to fit data uploaded from excel and the “=csv” leaves out columns and tables that I need. So, I changed the URL to be “.xlsx” and “.xls” instead of “?format=csv”. Yesterday, this worked fabulously, but today the access to the forms were denied (for some reason…). So, I decided to go back to square one since that at least kept the connection active even when I closed Power BI og logged off of KoBo (both of which had severed the connection for the “xlsx” plan… I really appreciate any advice on this!

Thank you so much again!

[Kal_Lam]

Are you using the OCHA server?

[j_fog]

Yes

When I opened Power BI today, the error message read:

• Query ‘ABC’ (step ‘Reordered Columns’) is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.

Then I would refresh the dataset and get this message:

• An error occurred in the ‘Test_6_’ query. DataSource.Error: Web.Contents failed to get contents from 'https://kc.humanitarianresponse.info/api/v1/data/XXX.xlsx (500): Internal Server Error
  Details:
  DataSourceKind=Web

[Kal_Lam]

@j_fog, well as a quick check would you mind trying it out by making your data public to see if that works?

[j_fog]

I see how you are thinking and that is definitely a plausible solution. Although it is fine to try this out with a prototype, I would need the connection to work without making the data public. I understand if that means I have to manually download and upload the data onto the Power BI using excel. Do you know if there is any other way around it?

Thank you so much for your advice! I truly appreciate your help.

[Kal_Lam]

If you do not wish to make your data public, try as outlined in this Microsoft Doc (it should help you solve your issue):

Authentication with a data source

[j_fog]

You are a star! Thank you very much

[j_fog]

Hi again, unfortunately I could not manage to make it work… I am exploring other options for connecting data. In any case, thank you so much for your advice on this! I will make a post if I am able to solve it