Forum Discussion
Incremental Refresh misunderstanding ?
Hi FXFelix ,
Incremental refresh enables very large datasets in the Power BI Premium service with the following benefits:
-
Refreshes are faster - Only data that has changed needs to be refreshed. For example, refresh only the last five days of a ten-year dataset.
-
Refreshes are more reliable - It's no longer necessary to maintain long-running connections to volatile source systems.
-
Resource consumption is reduced - Less data to refresh reduces overall consumption of memory and other resources.
For more details, please check the online document.
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
Hi and thanks for your answer.
I had read that link before my post, but it did not enlighten me :)
Let's explain what is hard for me to understand...In one of my report, I want to show data from 2017 to now, and I want to refresh only the last 3 months.
So I have set up incremental refresh in this report, RangeStart value to the first of april and RangeEnd to the first of july, for example. But applying those parameters in the Power Query editor delete data before RangeStart in the report.
So how can I show the data before the RangeStart if this data is absent from the report ?Hey FXFelix ,
In this sections of that link (https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh#refresh-ranges) the article explains how to keep the older data. Also, if this isn't working the way you expect, you can get everything ready for incremental refresh and then run the report so that all the data you expect comes in and THEN turn on incremental refresh and from then on it will keep adding the data you need.
