Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Incremental Refresh on a dataset with Dataflows as a data source

Hi,   I have a question about implementing Incremental Refresh on a dataset that connects solely to Dataflows. I tried setting it up but it appears Dataflows do not support query folding.   Few q...
Dataflow
Need Help
anselmojg's avatar
anselmojg
Advocate II
5 years ago

We have the very same question (dataset incremental refresh using dataflows as source, regardless of how the dataflow itself gets its data).

Has this been answered?

pat_mecee's avatar
pat_mecee
Frequent Visitor
5 years ago

The simple answer is NO.

 

Many have tried workarounds, but nothing official from @microsoft.

  • ldacey's avatar
    ldacey
    Advocate I
    5 years ago

    pat_mecee Have you tested this? I ran a test and it seemed to work, but I did not proceed (my responsibility is just to create the dataflow sources and I do not use PBI Desktop or datasets much).

     

    It would be nice to have official communication here. 

     

    https://docs.microsoft.com/en-us/power-query/dataflows/incremental-refresh#dataflow-incremental-refresh-and-datasets

     

    "Dataflow incremental refresh and dataset incremental refresh are designed to work in tandem. It's acceptable and supported to have an incrementally refreshing entity in a dataflow, fully loaded into a dataset, or a fully loaded entity in a dataflow incrementally loaded to a dataset.

    Both approaches work according to your specified definitions in the refresh settings."