Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Please help with the incremental refresh with the parameter filter

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.

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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: