Forum Discussion
Incremental refresh doesn't work
Hi, I hope you're all doing good and could help me to handle this issue...
I have Power BI Premium account (not sure if that's relevant though) and in Power BI desktop, I created a query defined RangeStart as 2019-01-01 01:00:00 and RangeEnd as 2019-01-01 01:01:00:
I filtered the related dataset in the query:
I refreshed the report and it showed only the data which has CREATE_DATE between 2019-01-01 01:00:00 and 2019-01-01 01:01:00, and that makes perfect sense. Then I set the incremental refresh in the report:
Then I refreshed the report. It reloaded the data but nothing has changed. It kept showing me the data which has CREATE_DATE between 2019-01-01 01:00:00 and 2019-01-01 01:01:00. My first question Q1: Is this normal?
Then I published the report in Power BI services and did refreshing there and again it kept showing me the data which has CREATE_DATE between 2019-01-01 01:00:00 and 2019-01-01 01:01:00. My second question Q2: How can I fix that?
In everywhere it's said that the dates that you choose for RangeStart and RangeEnd don't matter. However, in my case they seem like only things that matter!
What do you think?
Note: I tried to check whether the query is foldable or not but I am a bit confused, some relates visibility of "View Native Query" with foldability. And while that's greyed when I check the "Source" step, it's visible when I check other steps.
11 Replies
- mwegenerMost Valuable Professional
- v-kelly-msftCommunity Support
Hi 1123 ,
Q1: It's normal.
Q2: You can change the parameter of RangeStart and RangeEnd to change the time period you need for refresh.
Dates that you choose for RangeStart and RangeEnd of course matter, here is the reference.
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
Best Regards,
KellyDid I answer your question? Mark my post as a solution!