Forum Discussion
Dataflow Incremental Refresh: Data Is NOT Refreshed on Monthly Cut
Hi,
I have an issue with data flow and would like to gather some insights on it.
My dataflow has the below settings:
- Daily Scheduled Refresh
- Incremental Refresh
- Store rows from the past 10 years
- Refresh rows from the past 1 month
I have been having this setting for a while, and everything is working just fine.
However, today (2/1/2022) I noticed, without any refresh errors, the 1/31 data is not showing in the dataset?
I am wondering is it because of my incremental refresh setting, even though I assume the incremental refresh is refreshing under the rolling calendar manner? For instance, on 2/1/2022, the window of the past month, 1/1/2022-2/1/2022, is the period of time that is refreshed.
Thank you in advance!
2 Replies
- GilbertQ
Super User
Hi Anonymous
One thing to note is that the Power BI Service runs in the timezone of UTC, so what this means is that at the time of refreshing the timezone in UTC might still be 2022-01-31 and that is why you are not seeing the updated data?
- v-luwang-msft
Community Support
Hi Anonymous ，
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
And current power bi service only support UTC datetime. It not contain any features can auto transform datetime based on location.
refer:
Best Regards
Lucien
