Getting repeat questions into Power BI

[sergiousme]

Hi everybody.

I found on this forum this excellent video provided by @janna that explains how to connect KoBo to Power BI.

Nevertheless, the data loaded into PBI is just the data from the main form, and not the data from the repeat questions.

Is there a way to do so, hopefully as easy as the method provided by @janna?

Thanks!

[Kal_Lam]

Welcome to the community, @sergiousme! Maybe this post discussed previously should help you solve your issue:

Managing repeat groups with Power BI

This is quite off-topic from this thread, it would be better if you started a new thread. One possible solution would be using the Power Query Editor (Home ribbon, Transform data button). Select all the other columns (besides lat and lon), then choose Group By. In the Group By pop-up choose Advanced. Choose Add aggregation, then choose New column name = lat, Operation = Max and Column = lat. Repeat for lon. You can delete or ignore the default Count aggregation. It should then summarise the …

And this post too:

Pulling data into Power Bi via API: Skipped questions at set up not added when answered post set up

Thanks. Are you sure that you tested it with AT FIRST no entries in the repeated questions, then established the API and THEN enter data in the repeated questions? By the way, if I follow the recommended video (which I consulted several times before), during the get data procedure no “Navigator” windows pops up with SEPARATE tables. [image]