Forum Discussion
using parameter to filter out datetime column however the end date is outside the range
hello! I used parameter to filter out a datetime column in my table via power query, then I close and apply. However I found the datetime is outside the range of filter. This is my parameter.
However the last datetime of conversation_opened is
In power query:
Table.SelectRows(#"Sorted Rows", each [conversation_opened] >= RangeStart and [conversation_opened] < RangeEnd)
Could I know the reason why?
4 Replies
- DataInsights
Super User
Anonymous,
The parameter names RangeStart and RangeEnd are reserved names that are used in incremental refresh. Try renaming your parameters and see if that resolves it.
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
- DataInsights
Anonymous,
Assuming you created the incremental refresh policy correctly for this table, I would expect rows with the DateTime in your example to be excluded.
