Power Query updates in Excel 2016 (msi)

Rudi

Rudi

New member
Joined
Jan 18, 2014
Messages
134
Reaction score
0
Points
0
Location
Cape Town, RSA
Website
www.eileenslounge.com
Excel Version(s)
Excel 365 ProPlus
Hi,

I am running a standalone (installed version of Excel 2013 (Professional Plus (msi)) and have the latest update of PQ (version: 2.48.4792.941 32-bit).

If I had to get my company to update my Office installation to Office 2016 Professional Plus (standalone; not click to run or subscription versions), will the PQ component of Excel 2016 (Get and Transform) be as up-to-date as my add-in version in Excel 2013?

Can anyone give me some insight into this? I don't want to update to Excel 2016 if I will not have an up-to-date version of PQ? Does Microsoft provide Excel updates that keep PQ in Excel 2016 as up-to-date as the add-in version?

TX.

PS: I am aware of (and personally use Power BI Desktop) and am running the latest version of this too; but my question is in particular focused on PQ in Excel as the solutions I build is generally for data models we use inside Excel.
 
It should be, it should get packaged update releases. This is not as up-to-date as Office 365 which gets the first updates as soon as MS are ready to release.
 
TX for the reply, Bob.

Based on your reply I will have to consider remaining with Excel 2013 then if the add-in component is more frequently updated than the packaged updates for Excel 2016. Alternatively I can hint on my company getting the subscription version of Office 2016. AFAIK, the click-to-run version is updated faster than the installed (msi) version.

Cheers
 
No, that is not what I said Rudi. Office 365 is more frequently updated, but you don't have Office 365 now, nor will you with 2016 Professional Plus. In 2016 Power Query is built-in but it is still dependent upon a release cycle, as is 2013. You should be just as up-to-date with 2016 as you would be with 2013 (maybe even more so if it is easier to update the built-in version than the addin, but that is pure conjecture).
 
Hey Rudi,

Official word from the Program Manager who works on the deployment of new updates:

Excel 2016 perpetual customers will get all the new Power Query features (i.e., will get the monthly updates).

New data connectors (e.g., SAP HANA connector) and new Excel integration features (e.g., the modernized Get & Transform experience) are reserved for Excel 2016 subscribers only.
Click to expand...

Hope that helps!
 
What does ' ... the modernized Get & Transform experience ... mean Ken?
 
... are reserved for Excel 2016 subscribers only is what menas that those on subscription version get all the new bells and whistles that aren't available to others. But I didn't ask that, I already knew that and had said as much in response to the OP. I asked what a particular phrase that this Program Manager used meant in English rather than MS sales-speak.

I seem to be blessed today with people who answer questions I didn't ask.
 
You must log in or register to reply here.
Back
Top