Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I use incremental refresh to refresh only the last few days of electrical market values.
My problem is that the last value is the one of the next day (1 day in the future) and incremental refresh refreshes only the values until the current day.
I saw this topic from 2018 Incremental Refreshes - how to accomplish future d... - Microsoft Power BI Community and the given solution is said to be reserved for premium capacity owners. Is it still the case ?
And if it is, do you know any workaround to manage incremental refresh until tomorrow's date ?
I thought adding a column with a one day shift in the past compared to the query's date column, but maybe someone has a better idea ?
Best regards
Cado
Solved! Go to Solution.
Problem solved :
I added a column with a one day shift in the past compared to the timestamp of the data.
This way incremental refresh based on this one day late colum refresh until the date of today which corresponds to the date of tomorrow for the date column used in the query.
Have a good day
Cado
Problem solved :
I added a column with a one day shift in the past compared to the timestamp of the data.
This way incremental refresh based on this one day late colum refresh until the date of today which corresponds to the date of tomorrow for the date column used in the query.
Have a good day
Cado
@Cado_one Incremental refresh used to be a Premium-only feature but is now available for Pro as well.
I know incremental refresh is available because I use it. My question concerns the possibility to incrementally refresh a table until a date in the future.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |