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

[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!