do i need incremental refresh

[powerbiexpert22]

i am using import mode in reports

my reports refreshes daily once, weekly once and monthly once

my reports take maximum half an hour to load on power bi service

my reports shows historical data for 2022.2023 and 2024 (till now)

do i still need incremental refresh ? i am confused,  as per my understanding incremental refresh is needed when report refresh takes lof of time 

[Ritaf1983 · Accepted solution]

Hi @powerbiexpert22 

According to the scenario you described:

• Current Refresh Times: Your reports currently take a maximum of half an hour to refresh, which is quite reasonable.
• Historical Data: Your reports cover historical data from 2022 to 2024. If the size of your dataset is not overly large and the current refresh time is acceptable, incremental refresh might not be necessary at this moment.
• Future Growth: Consider the future growth of your dataset. If you anticipate significant data growth, implementing incremental refresh now can prepare you for future needs.

Decision

Based on your current refresh times and dataset size, incremental refresh may not be urgently needed. However, if you expect your data to grow significantly or if you want to optimize your refresh process proactively, implementing incremental refresh can be beneficial.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[powerbiexpert22]

thanks a lot @Ritaf1983 😊

[Ritaf1983]

Happy to help ☺️