Forum Discussion
Incremental Refresh Azure Blob
RangeStart and RangeEnd cannot be both inclusive. Usually RangeStart is inclusive and RangeEnd is exclusive.
You cannot use Date columns, it must be DateTime or DateInteger.
I see. My column is a DateTime. I'll adjust the RangeStart and RangeEnd, but I don't think that's the problem.
What is your reasoning for doing this in the first place?
I have historical data in azure blob that is immutable, so I don't need to update it every time I need to update the report. That's why I want to implement incremental refresh, taking only the last 7 days, for example. But the big difficulty here is structuring the incremental refresh in the best way, and I'm not succeeding. I believe that the Azure Blob bases don't support query folding, and this may be considerably impacting the incremental update and I don't know what to do about it 😥ğŸ˜
