Forum Discussion
Help working with big data: limit rows to reduce file size
Hi guys, I need help with the following: I have a file with many rows, apart from being heavy, I can't finish applying some changes in Power Query due to "memory problems". So what I'm wondering ...
Hello Anonymous ,
Try using incremental refresh, so you would archive a specific period of data and only refresh the lat month or 2 or even 6.
check this to know more about incremental refresh and how you could set it up https://www.youtube.com/watch?v=Kui_1G6kQIQ&t=148s
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Idrissshatila
Super User
Super UserHello Anonymous ,
Try using incremental refresh, so you would archive a specific period of data and only refresh the lat month or 2 or even 6.
check this to know more about incremental refresh and how you could set it up https://www.youtube.com/watch?v=Kui_1G6kQIQ&t=148s
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍