Forum Discussion
wagrezy
Helper I
6 years agoGrouping large data
Hi all, I'm connected to a large dataset (.txt 600 MB) hosted on a sharepoint. As I do not need all details in the dataset, I am grouping the data to make it smaller. However... I'm questionning ...
- 6 years ago
wagrezy , Anything you do in edit Query or data transformation mode is better
https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks
https://www.poweredsolutions.co/2019/07/30/grouping-rows-with-power-bi-power-query/
https://www.youtube.com/watch?v=pSIqhYR2HRU
amitchandak
Super User
6 years agowagrezy , Anything you do in edit Query or data transformation mode is better
https://docs.microsoft.com/en-us/power-bi/desktop-common-query-tasks
https://www.poweredsolutions.co/2019/07/30/grouping-rows-with-power-bi-power-query/
https://www.youtube.com/watch?v=pSIqhYR2HRU