Incremental Refresh

[JoergSch]

Hello!

I am currently working to create a report which a huge amount of data and using the Incremental Refresh functionality to get the data.

With that, I have few question and hopefully get an answer here.

1) When I develop the report, I set the RangeStart and RangeEnd. E.g. when I set todays date for the RangeEnd, but then publish the report in 2 weeks, does it automatically use the "current date" as RangeEnd or do I have always to update the RangeEnd before I publish it?

2) What happens when I delete a data in the backend? Do I need to do a full refresh?

Many thanks for your help.

Joerg

[v-xiaotang · Accepted solution]

Hi @JoergSch 

Thanks for reaching out to us.

you don't need to update the RangeEnd before you publish it.  RangeStart and RangeEnd, defined in the Manage Parameters dialog in Power Query Editor are initially used to filter the data loaded into the Power BI Desktop model table to include only those rows with a date/time within that period. After the model is published to the service, RangeStart and RangeEnd are overridden automatically by the service to query data defined by the refresh period specified in the incremental refresh policy settings.

For more, please read this article https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

And its 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.