Forum Discussion

areeg mohamed's avatar
areeg mohamed
Copper Contributor
Jun 30, 2017

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 enable the add-on and import database file to work on it in Excel ?

BI & Data Analytics
Excel Desktop

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 30, 2017

    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.