Forum Discussion
Incremental Refresh
Yes, perfect. Change the parameters and Business Date column from Date to Date/Time data type:
Environment - PowerBi connected to local Sql Server
Current Process - Whenever we update new data in Sql, we refresh the complete data which takes almost 1.5 hours as there are more than 27 million lines. Once the data is refreshed in power bi desktop, we publish the same for all users.
Assumption : Incremental refresh would reduce the time as it would refresh only the delta data.
Step Taken as below
Table Name - Articlewisesale
Column Name - Business Date
1. Clicked on transform data
2. created 2 parameters
RangeStart = 01/01/2020
RangeEnd = 31/12/2025
3. Custom filtered the column business date with above parameters
4. Complete data got loaded once.
5. not able to get rid below error
Can you post screenshots so that we have more details about your issue?
Hi otravers
Acutally, I have implemented the Incremental refresh on a table but its taking the same time to refresh as the Normal Full Refresh.
Any Ideas? what will be wrong?Read the part about query folding in the following doc, lack of query folding is the most likely reason why incremental is not really happening and you end up doing full refreshes:
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#query-folding