All columns do not appear when connecting to powerbi

[Kal_Lam]

@sara_7500, linking you to this post so that you could benefit from the discussion that has happened here.

[tomisin]

Well done @nat

Yes, I have repeat and nested questions, and extracting them to power bi is straightforward with all results returned clearly.

Kind regards

[sara_7500]

Hi
I face the same problem on missing fields in power bi , i am not understanding step number 2.

[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