Power Query - cache shared nodes
Update Power Query in Excel to take advantage of caching in cases where a parent node refers to a child node that has already been refreshed (as exists in Power BI desktop today).
This issue creates significant performance problems with refresh times when creating highly interdependent financial and operational models. This is a show stopper from a usability and customer acceptance standpoint.
We are happy to announce that the feature is finally available on Production starting from July fork (build 16.0.10726.*) for Office 365 subscribers.
Thank you all for your votes and the feedback.
- Excel Team
@inetguru - never. You have to have office 365 subscription for new features. Or buy 9office 2019 when it comes out. But that will not get new features after it is released either. Just security and bug fixes.
@admin how can we tell if this runs faster? We are on the monthly targeted release and therefor have had this since Jan 2018. No way to know if it runs a faster. I cannot recall how something ran with build 1712.
When do you plan to release an update for Excel 2016?
Nick Caton commented
I am so excited to see this issue getting addressed!
Graham S commented
@Ed Hansberry - one could argue it's not a new feature but an existing one they have now got right ;-)
At last... hope it will not take long
@anon- if you don't have Office 365, meaning you have a perpetual license for 2016, you'll have to buy Office 2019 or subscribe to Office 365.
If you have Office 2010 or 2013, then I don't know if/when they will add this functionality to that Power Query addin. I kinda doubt they will, but who knows. But I doubt they will issue an update to Office 2016 perpetual license users. They never issue new features for perpetual licenses, just security updates.
@lauren - you absolutely need the data model to build pivot tables using Power Pivot, which gives you the ability to use multiple tables, relationships, measures, etc.
if you aren't using the data model, then you are using pivot tables the old way which requires a single flattened table in a spreadsheet. Horribly inefficient the larger the table is.
Lauren Shumway commented
Re not using data model: you don't need data models to build pivot tables. It appears from my experience that that data models used in conjunction with a set of underlying, structured queries magnifies the performance issues.
@Walter Pelowski: I don't have 365 on my home PC. Now what?
The developers were already crazy with the functionalities included in the different 365 packages (PRO, E3, standard, home, MSO ...) but if we add the channels .... Each client we have has different version in the packages and of course different channel version.
All this, as you can suppose, takes hours to try to investigate where the problems are.
When the files are shared, it happens that they are edited by different users that have different versions and, of course, different channels (the new buzzword), all this leads to MANY problems of various kinds.
I beg you, to facilitate the work of the people who develop solutions with your tools that we consider fantastic and that we recommend our clients to continue using.
Walter Pelowski commented
FWIW, I don't see anything in the release notes about this in version 1801 build 9001.x
Walter Pelowski commented
Some additional info on how to check/verify/change update channels.
To find your Office 365 Version
Information on Update Channels
Article about how to switch channels if your settings allow it
I've done this on my machine at work to get to the Monthly release channel while most of my colleagues remain on the Semi-annual Channel (Targeted)
How can you tell when it's updated on your home PC? Is it monthly by default?
Excel guru.ca, please provide clarity. Have you used it yourself? Have you noticed any improvements?
Go to File, Account. Will show which product, version, build, who it's licensed to etc. Semi-annual means the updates get pushed to your PC twice a year instead of monthly, likely chosen by your IT dept.
How do you know which version & build you have? And what is a semi-annual channel?
Someone can correct me if i'm wrong, but it appears that the semi-annual channel gets the update in July.
Nicolas Bransier commented
How do I get 1801 build? I’m still on 1708 even after clicking on Update Now a couple times. Wondering if it’s because i’m On Semi-annual Channel.
Jeremy Klein commented
If this has been fixed in version 1801 build 9001 than that means it was fixed back in January. We still have the problem today. And this thread still shows it as "STARTED" not completed. I hope it has not been completed yet, because it is still very slow.