Forum Discussion

arridhonabil's avatar
arridhonabil
Frequent Visitor
5 years ago
Solved

Incremental refresh on Source Table or Result Table

Hi All,   I'm having issues in applying incremental refresh for my data set.    I have source table imported from data flow, let's say it is table A (disabled load). Then I create manipulation us...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    "Load Disabled"  is just eye candy. The Power Query engine will decide if the lineage requires the table to be processed anyway.

lbendlin's avatar
lbendlin
Super User
5 years ago

Incremental refresh most of the time only makes sense for fact tables. 

While you can run incremental refresh on both a dataflow and its "child" dataset this seems to be rather excessive.  Dataflows are designed to be ingested very fast, regardless of size. So having incremental refresh on the dataflow should be sufficient. Note:  The setup process is slightly different.  You do not need to create the RangeStart and RangeEnd parameters in a dataflow, the Power BI Service does that for you.  On the dataset you need to create the parameters.

arridhonabil's avatar
arridhonabil
Frequent Visitor
5 years ago

Hi lbendlin ,

 

Thanks for the feedback. I understand for dataflow, we dont need to set that up. But for my condition I'd like to put the incremental refresh on Result Table Level or the data set in desktop. Could you share your view for the 3 tables if you've experienced this?

 

Thanks