Connect Power Bi to Kobo api but in XLSX format or CSV not in JSON format

[HannaJAK]

I need to connect power bi to xlsx version of my kobo survey not json.

I tried so many links. Here is my form id: amfKew3d7Eyh9zg4mcacC9

Please help me, what is the link and what is config I should do.

[HannaJAK]

I want to connect power bi to kobo but not gettinig json format data, I want labels, and I do not want to use export settings because this will not make the data in sycn, I have to go export data and add new export setting. we were used t oconnect directl and get the lables, what has changed, please help

[Kal_Lam]

Welcome to the community, @HannaJAK! Feel free to go through this community post discussed previously.

New columns added to the Kobo survey also get reflected in Excel/Power BI

Hi @Abessolo and welcome to the community. I have had this experience before and it seems like you will need to update endpoint URL which carries your data. Taking from this article - Connecting to your data using synchronous exports — KoboToolbox documentation Create another export of the data and make sure the new fields are included in that export - This creates another endpoint URL. Check the endpoint URLs - You should be able to see two URLs now and take a look closely on the versio…

It should help you solve your issue!