Trouble with API connection Kobo to PowerBI

User Support API
, , ,
1

Hi all,

I encounter this problem when I connect KoboToolbox API to PowerBI. The response is shifted to another column like shown in the image below:

image
image1183×833 76.3 KB

in KoboToolbox, the data was fine,
Any feedback is appreciated.
Thank you!

2

Welcome back to the community, @midoen! Could you check if your data has any line breaks?

3

There’s no line breaks on the value.
It does have commas, although I formatted the API to csv, I don’t think that’s the problem.
It worked well when I formated the API to json, the problem occurs when I use csv.

4

@midoen, did you also try using the xlsx type to see how it behaves?

5

Hi @Kal_Lam, I did try it. It returns to something like this:
image
The “Open As” is not clickable.

6

@midoen, does it behave in the same way when you connect your data with Excel Power Query?

7

Hi @Kal_Lam ,
Thank you for your response.
I’ve tried connecting my data with Excel Power Query, and it’s the same.

image
image1435×867 94.7 KB

8

OK, as a cross-check, identify the _id and the variable that has this issue. Download your data in Excel format, and then check out to see if there is a line break in that response. There were similar cases reported previously, so I assume it’s the same case.

9

Hi @Kal_Lam ,

Apologize for just responding to your reply.
Yes. There is a line break, especially on the “Address” (text type question).
Is there any workaround to solve this?
Cheers!