Forum Discussion
Does someone know if bi-directional cross-filtering will appear in Power Pivot?
MicrosoftI seem to have missed this thread.
Power Pivot isn't legacy, it's a core part of Excel analytics going forward. We're working on improving the quality of experience with the data model & Power Pivot, and for those on subscription, you'll start experiencing slight improvements, initially ~invisible, more focussed on quality.
Part of the work we're doing is to make sure the data model works well with across different versions Excel.. given the wide deployment cycles, we think it's necessary that one person using the latest version of Power Pivot doesn't suddenly cause others downlevel to have data model load failures. As you can imagine, this is substantial work. Once that foundation is laid, updates should be more frequent, we can't wait for that day!
thanks
ash
Ashvini Sharma
Excel
Now that the Excel 2019 Preview is released can you elaborate on PowerQuery and PowerPivot enhancements included in Excel 2019?
- Ashvini Sharma
Hi all,
Since my last update, for Power Pivot, the bulk of our energy has been focused on quality improvements as well as supporting simultaneous coauthoring of BI objects like PivotTables. All of these are available for subscription customers. We have a little more of these remaining, and I look forward to then updating the database compat level to support new modeling features. Note that we've been shipping new versions of the engine periodically, so new DAX functions should be available.
For Power Query, there've been a stream of continuous updates for subscription customers.
To simplify, think of Excel 2019 ("perpetual release") as a snapshot of what we've been shipping to subscription customers rolled up into a release. For Power Query, this would include it being the new default, new transformations, column by examples, etc. For Power Pivot, this is mainly quality improvements, updated dialog for relationships creation, printing support in diagram, updated linked tables, updated measures editing experience, etc. In addition, there's a pleasant surprise for most folks (hint: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9018823-make-power-pivot-available-in-all-versions-of-exce).
The best place to keep up with what's new is on our what's new pages: https://support.office.com/en-us/article/what-s-new-in-excel-2016-for-windows-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73?ui=en-US&rs=en-US&ad=US.
thanks
ash
Ashvini Sharma
Lead Program Manager
Excel