Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Native query with 5 tables join to do Incremental refresh in report

Hi All,

I have 5 tables . I created join query and use as source to my report.  Date field exist in "A" table and no date field in rest of 4 tables. I have create rangestart and rangend parameters and filter the data in power query.

 

Now my question new date added to 4 tables "B,C,D,E" & No data added to "A" Table so date is not updated. when I do incremeental refresh so new data added my 4 tables or not?

 

PowerBI 

Show and Tell

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Have you validated that your query still folds after the append? at the step where you add the Range filters ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Yes...Query folding is woriking for my source and range fileters added to query aswell.