All columns do not appear when connecting to powerbi

[nat]

@nat

KoBo enhancement to add a toggle in the API to request the JSON to always return fields even if empty for a given record (which would massively increase the size of the data file if there are lots of empty fields) - this is what @tom.joseph is requesting here.

I have now logged an enhancement request in the Suggestion box for this: API - ability to get full extended submission schema - so PBI knows the structure to expect