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 show your filter step in Power Query for the Articlewisesale table?
I hope I sent you the correct screenshot
Yes, perfect. Change the parameters and Business Date column from Date to Date/Time data type:
Thanks a ton. You are awesome. Now I know exactly the place to come to for my Power BI queries.
Thanks once again.