Forum Discussion

JoergSch's avatar
JoergSch
Frequent Visitor
4 years ago
Solved

Incremental Refresh

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 ...
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    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.

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

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.