Thanks for all the feedback on this! We are definitely planning on adding Incremental refresh to Pro. Do know though that it is a fair amount of work, so it may be a bit before we can give you a more firm timeline.
In the meantime, keep voting so you’re notified when we do have more information to share!
Good to hear Amanada, please keep us informed with regular updates.
Surely the bulk of the work has already been done in making this available to Premium customers?
Could you clarify if incremental refresh works when the data is exposed to Power BI via SQL views, rather than pointing it directly at the tables?
As Gordon Kennedy says below, this is pencilled in for Pro at some point in the future. This has also been restated by Will Thompson at https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7288623-incremental-data-loads
Finally done in the March 2019 Update (2.65.5313.501)
Single selection now works as expected in the March 2019 Update (2.65.5313.501)
This has now been done in the March 2019 Update (2.65.5313.501)
@Alexis Olson - Unfortunately that says what they have done, not what they are planning to do.
Absolutely need either a new Navigation pane, or the ability to put slicers on the Filter pane.
We’re looking into this request, thanks for everyone’s votes and comments.
It looks like many of the requests will be addressed by the new ‘Sticky filters’ capability. Now when you log out of Power BI and come back to a report, the same items will be selected as when you left.
For those who’re looking to have a ‘last month’ selection, the relative date slicer might help.
Those with comments about currencies where having multiple selected makes the report meaningless – the report will load with whatever selection the author saved, so if you save it with one currency selected your users will see that by default.
If there are scenarios that these features don’t address, please let us know in your comments – if you are really specific it’ll help us build the feature to work just the way you want!
Sticky filter selections were added nearly a year ago. If you set the slicer to 180 days and publish, will this set the default for your users?
As already mentioned, for lists and drop downs, there are two big issues at the moment:
1) If single select is enabled then you should not be able to unselect your item and have it show All. The slicer should force the user to select a different item.
2) For default values, sticky filters is not a solution as due to RLS different users may have different selection options. One possible and seemingly easy solution would be to have a 'default to first/last' option.
I am loathe to start a new idea when this is officially under review, so I hop these quick wins will be taken on board.
C'mon Microsoft. How about an update on this as a Christmas present? It is is pretty fundamental reporting requirement.
is there any news on this Microsoft? I fail to see how so many years down the line this still hasn't been implemented.
How can copy and paste features take preference over a fundamental reporting data type?
Is anyone from the Power BI team going to comment on this? How many of your users have a requirement to plot durations on a chart?
Unbelievable omission. Would anyone like to guess what an average elapsed time of 1443279 seconds is? Of course not, it's nonsense.
What is even more bizarre is that when you Edit Query there is a type of Duration.
Is there any comments from MS employees on progress of this feature, as without it Power BI is unsellable to our customers.
You also cannot switch between modes if you hide the header and show only the title, which seems like a UI design issue.
Support for fiscal calendars would also be extremely useful.
Excellent idea, although I'm not sure how you would configure the fiscal calendar start and end dates, how many fiscal weeks and months there would be, and how the weeks/months would be allocated to fiscal quarters.
Agreed. This seems an odd design decision.
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!
Can you also add support for fiscal date slicing? This is pretty fundamental in the corporate world.