I’m sorry I didn’t follow the entire thread, but after using Kobotoolbox & power BI for nearly 5 years I can confirm that questions that have never been answered (due to skip logic) will not show up in Power BI through the API.
There are two workarounds to this:
Number one is to fill in one submission that answers all the questions. Once you set up the Power BI query, you can delete that submission.
In order to make it easier to fill this initial submission, you can disable all skip logic temporarily by editing the ‘required’ column in the form excel. Then once you have uploaded this submission, you can replace the form with the original excel file.
The second method is to manually add these column names into Power BI when you are setting up the query. Usually it’s this step (you have to add each field to the list of fields to expand):
= Table.ExpandRecordColumn(#TableName, Columnname, <List of fields>)
I don’t know how it works with repeat groups though, because I’ve never used it.
