Please help with the incremental refresh with the parameter filter

[Anonymous]

Hi, these are the two parameters:

Then I used the steps to filter the table:

however I get the results outside the filter range:

Then I did a test, I insert one step to change the type of this column and after this step I made the same filter rows again:

My regional PowerBI setting is UK format.  Now I got the filter rows is within the range.

I can not understand this. Can someone help me on this? should I insert this step "change type with locale" or not? it seems it will not affect the final result of incremental refresh in my testing, isn't it?

My data is from postgresql server.

[amitchandak]

@Anonymous , Make sure all have datatype datetime.

Share the filter condition?  hope that is on correct table

Power BI Incremental Refresh Pro; Premium Deployment pipeline - https://youtu.be/nIxTRdeCYSE

[Anonymous]

@amitchandak Thanks, pls see the filter:
= Table.SelectRows(#"Sorted Rows", each [conversation_opened] >= RangeStart and [conversation_opened] < RangeEnd)
I am sure the  [conversation_opened] column is datetime type. 

the column in SQL table is like this: