Forum Discussion
Setting up incremental refresh
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?
2 Replies
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.
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.
