Forum Discussion
Incremental refresh > no data > Empty partitions
Hi Anonymous
The reason is that you need the start to be >= and the end to be <This happens because when the data is passed it does it for your example as the following when sent via PBI it would be:
where [_].[Loaddate] > convert(datetime2, '2022-03-28 00:00:00') and [_].[Loaddate] < convert(datetime2, '2022-03-29 00:00:00')Based on your example if you could change it to the following:
= Table.SelectRows(HCS_vw_Feit_verrichtingenTest_incremental_load, each [Loaddate] >= RangeStart and [Loaddate] < RangeEnd)
Super UserHi Anonymous
The reason is that you need the start to be >= and the end to be <
This happens because when the data is passed it does it for your example as the following when sent via PBI it would be:
where [_].[Loaddate] > convert(datetime2, '2022-03-28 00:00:00') and [_].[Loaddate] < convert(datetime2, '2022-03-29 00:00:00')
Based on your example if you could change it to the following:
= Table.SelectRows(HCS_vw_Feit_verrichtingenTest_incremental_load, each [Loaddate] >= RangeStart and [Loaddate] < RangeEnd)
The difference an equal sign can make 😅
- GilbertQ
Yeah those small things make a big difference!!
After few days of deep dive into potential query folding problems here is the answer for my issue, simple and straightforward 🙂 Thank you!
