Getting repeat questions into Power BI

[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]