Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 "is this the right approach?" as the grouping step is quite heavy in terms of performance.
Overall, is it worth doing many steps in the "transform data" part given it's quite heavy and weight on performance? Or is it better to leave the data as raw as possible and manage as much as possible in the report part?
thanks
WY
Solved! Go to Solution.
@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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |