Loading Repeated grouped questions on PowerBi via API

[Roggers_k]

Hello community, i am having difficulties in handling repeated group questions; to load them on PowerQuery in PowerBi.
I have connected my kobo to PowerBi using Jenna’s tutorial.

The repeated group responses are appearing as a list.
I have attached a screenshot

[Kal_Lam]

Welcome back to the community, @Roggers_k! Have you tried loading the repeat groups with Excel Power Query to see if you can load there successfully?

[Roggers_k]

Thank you for the prompt response. No, i have not. and i am not so savvy with Excel Power Query

[Kal_Lam]

It uses the same API. Maybe you could give it a try.

[kienl]

HI @Kal_Lam.

I have same issue with the @Roggers_k.
I tried to pull the data with Excel Power Query by API ‘https://[KPI]/api/v2/assets/{asset_uid}/data.json’, but the “repeated group” still appeared as a list

[Kal_Lam]

@kienl, have you tried this API (discussed previously)?

API Export to Excel Drops Hyperlinks to Photos

@mark_ej, we will be updating our support document very soon. Till then, maybe you could follow the steps outlined below: Step 1: Open your survey project and then make some downloads (by specifying a name to the Save selection as ...) as shown in the image below: [image] Step 2: Now in a new tab, use the following API: https://[kpi]/api/v2/assets/{asset_uid}/export-settings/ Here, kpi refers to kobo.humanitarianresponse.info if you are using the humanitarian server else kf.kobotoolbox.o…

[kienl]

Ah, it’s worked if I used this method.

Thanks so much.