Forum Discussion
Power Pivot
Hello, I need some help regarding Power Pivot. First of all, I do have Office 365 Home Edition. Does this version support it or not? If not, which versions support it. Also, what are the steps to ena...
Hi,
Nope, Power Pivot is not available for Home edition, which versions are supported is here https://support.office.com/en-us/article/Where-is-Power-Pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b
With Home edition you have limited functionality to work with data model. You may use Get & Transform to load the data into the model; you may add DAX-calculated measures using PivotTable; you may use linked-back excel tables connected with data model using DAX expression. But all above are workarounds, no way to enable Power Pivot for Home edition.
Former times you was able to install stand-alone full-functional Excel in parallel with O365 Home. Now when on-premises installations are also on CliclToRun that doesn't work.