We’re pleased to announce that in the May release of Power BI Desktop you can now define incremental refresh policies for your models.
At present these only apply once the model is published to a Premium workspace in the Power BI service; we’ll be bringing it to all Pro users in the future.
You can read more about it in our blog here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#incrementalRefresh
We’re going to leave this idea open for now, so please give us your feedback while we’re in this preview phase!
Waiting to get this feature in PowerBI Pro. I am loading a table that has 10 million rows and everytime i make change on desktop and refresh, it loads all 10 million rows although I have added a filter to only load rows that are for fiscal year 2018 & 2019, but it goes through the entire data set of 10 million rows and takes 4-5 hours.
The relative data filter is just working wonders. I love addition of the seven filters and makes it so easy for auto update and don't have to make changes each month. However we have current month "in this month", last month, "in the last = 1 calendar month" and we have current month last year, but that option is not available in relative data filer. It will be great that we can add "in this month" and the next filter is "in the last = 1 year" Looking forward to adding this soon. Or if we can enter -1 or in the last -13 months to show same month last year, etc.
The relative date slicer (a Preview feature as of June ‘17) gets us close to this with the ’This Month’ or ‘This Year’ settings. That is a dynamic date selection that updates based on the current system date. We plan to add a ‘YTD’/‘MTD’ option to specifically select a range from the start of the month/year up to today, hopefully that’ll address the remaining requirements!
I love the relative date slicer, which auto updates once set. However if we need to show "in this month" "last year" we cannot do that. I wish MS PBI can add in this month and then last year or in this day last year, or in this month last "#" years, so user can enter 1 for last year, 2 for 2 years back, or in this month in this year and user can enter -1 for last year, etc.