Forum Discussion
do i need incremental refresh
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
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
3 Replies
- Ritaf1983Super User
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
- powerbiexpert22Impactful Individual
thanks a lot Ritaf1983 π
- Ritaf1983Super User
Happy to help βΊοΈ