XML values instead of Labels in Power Query table

[Kal_Lam]

If you wish to work with the repeat groups, here is a post discussed previously (it should help you solve your issue):

Pulling data into Power Bi via API: Skipped questions at set up not added when answered post set up

Hi For capturing baseline data and recurrent updates, we have created a questionnaire (xlsform) which has become quite complex by now. There is a lot of skip logic and repeats – for instance, capturing either data on a school or data on a ECD centre, as well as asking for the number of preprimary classes and then for enrolment numbers of each of them. Janna’s wonderful youtube tutorial (https://www.youtube.com/watch?v=mDokTnjM6Fo&t=518s) worked perfectly to get the data from kf.kobotoolbox.org …