Hi to everyone, a question: I followed Janna’s steps and now my Kobo form is connected to Power BI, but I have grouped repeated questions, and as for the excel data analyser my excel file has 4 sheets and only the first was imported. Could someone have a solution?

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 Advanc…

Managing repeat groups with Power BI

User Support Data Management

iker.montes January 12, 2021, 7:57am 10

Try this, in the advanced editor of your query…

2 Likes