Forum Discussion
Missing columns (API connection from Kobo)
Hello mwsp_1,
Thank you for posting your query in the Microsoft Fabric Community Forum.
The synchronized XLSX export includes all columns, this indicates there is no issue with the form itself. The limitation you’re encountering is specific to how the JSON API is surfaced into Power BI from KoboToolbox.In this scenario, continuing with the synchronized export is a supported and stable approach, especially when form structures evolve over time. The JSON API can lag or expose a fixed schema depending on how the form version is handled, which Power BI cannot always reconcile automatically.
Thanks, Mauro89 for sharing valuable insights.Best regards,
Ganesh Singamshetty.
Hi mwsp_1,
it would be great if you might share your Power Query code to check if there is any issue there.
Beside that check these points:
Check the API response
- In Power Query Advanced Editor, look at your API call
- Verify the API is returning all fields - test the URL directly in a browser or Postman
- Kobo may have form version issues - ensure you're querying the latest form version
Clear the schema cache
- Go to the Source step in Power Query
- Edit the Web.Contents() or API call
- Add or modify a query parameter to force a fresh connection
- Re-apply all transformation steps
Best regards!
PS: If you find this post helpful consider leaving kudos or mark it as solution
