What Version of Office 365

[Mischief63]

I have the professional enterprise version of office 365 that I use for work. However I would like to purchase a home version with the full Power Query and Power Pivot capabilities. Does anyone know what version I should buy. Does it have to be a business version?

 

[SpillerBD]

Not anymore!
It is now in the O365 across the board, but not in the Home Disk version. Excel 2019 provides that to users who want that static version.
So glad

You may wish to examine the Office insiders program too. See ExcelIsFun on the new Array formula calculation engine and functions.

 

[Mischief63]

No kidding! I have been looking all over and it says you have to purchased Office365 proplus (which is what I have for work). I wish they'd make this clear on the purchase page, I purchased the business one before and there was no PQ.

 

[SpillerBD]

They did as well as either way, before and after.
Here's the read, which I only had because of the email...
Excel User Voice