Reply
djwbaker
Frequent Visitor

Incremental refresh to build data - snapshots

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?

djwbaker_0-1614671524801.png

 

 

many thnaks Dan

1 ACCEPTED SOLUTION
PC2790
Community Champion
Community Champion

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...

 

View solution in original post

2 REPLIES 2
v-cazheng-msft
Community Support
Community Support

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
Community Champion
Community Champion

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...

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)