Setting up incremental refresh

[audslloyd43]

Hi

We have a query to help with forecasting which now has 10 million rows at source and taking forever to refresh. 

I want to set up incremental refresh to only load the last month. 

Previous years data is already imported to the file. When I set up the refresh parameters and Click & Apply its as though Power Bi is running through the 10 million rows and I've given up waiting for it to complete.

Can I implement incremental refresh without having Power Bi seemingly run through all records of data? 

[v-juanli-msft]

Hi @audslloyd43 

Do you configure incremental refresh correctly?

Please check steps below:

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

No. The first refresh after you make structural changes will always be a full refresh (unless you use ALM Toolkit).

On the desktop you can artificially narrow the RangeStart and RangeEnd parameter default values to only work on a subset of the data.  Then in the incremental refresh setup you can specify how you actually want it to be partitioned.