Forum Discussion

markmsc's avatar
markmsc
Icon for Resolver I rankResolver I
1 year ago
Solved

adding non-parameterized conditions to semantic model incremental refresh

Hello to the community.   Our semantic model uses date-based incremental refresh. All tables have a PQ filter on them to select rows for refresh that looks like this:   = Table.SelectRows(Dimensi...
  • markmsc's avatar
    markmsc
    1 year ago

    Thank you again nilendraFabric -- your thoughtful reply led me to the solution.

     

    Indeed it was separating the two filter statements that was the key, because this allowed me to see the issue was simply with my syntax on the AuditIsDeleted column.  It's a bit/boolean column, and as shown in my query snippet above, I was trying to compare it in the filter to a value (0 or 1).  

     

    But in fact since PQ sees it as a true/false, no comparison is needed to get a true/false for the criterion -- the column itself is the true/false.  So I changed my filter expression to:

     

    = Table.SelectRows(Dimensions_Status, each [AuditPartitionDay] >= RangeStart and [AuditPartitionDay] < RangeEnd and not([AuditIsDeleted]))

     

    and it works as expected now!  Isolating that last part into its own statement let me work the syntax until I understood my error.  Then I just combined it all back into one filter expression and it's good.

     

    Thank you again for your help.  Very much obliged.