When using nested groups, only the latest data is accessible through api

[Kal_Lam]

Have you gone through this post, it should also be helpful:

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 …