Incremental refresh to build data - snapshots

[djwbaker]

Hi

used incremental refresh loads to spped the process of loading data, but i have a new project where i want to build a data set taking a daily snapshot
will this do the job?

many thnaks Dan

[v-cazheng-msft]

Hi, @djwbaker 

Yes, you can configure incremental refresh and use date function like NOW() to get data of specific day.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PC2790 · Accepted solution]

Hello @djwbaker ,

The parameters given look fine.

You can consider checking the two checkboxes as per your requirement.

Also ensure that the parameters for RangeStart are End are configured correctly.

I personally found this video very useful while setting up incremental refresh and might help you:

(701) All you need to know about incremental refresh for PRO | Power BI desktop update february 2020...