Forum Discussion
Incremental Refresh
Yes, perfect. Change the parameters and Business Date column from Date to Date/Time data type:
Hi, you're going to have to be way more specific about what you've tried, it's impossible to help you with such a vague question. Explain what you did, where you did it (e.g. desktop, service), and include screenshots. See the first link in my signature.
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:
