Forum Discussion

Copper Contributor

Nov 06, 2017

Solved

Power Pivot add-in lost - Office365 ProPlus

Hi, Yesterday I had some issues with the Power Pivot add-in - it wouldn't load the data model after connecting to external data sources through the query editor, which were loaded to the data mod...

BI & Data Analytics

Excel Desktop

SergeiBaklan
Nov 07, 2017
When strange if full repair didn't help. Latest option i know is full uninstallation of the Office by this fix https://support.office.com/en-us/article/Uninstall-Office-from-a-PC-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8?ui=en-US&rs=en-US&ad=US and install it again from scratch.

However, with that you will loss all your Office settings.

SergeiBaklan

Diamond Contributor

Nov 07, 2017

Hi Christoffer,

Office 365 itself is not enough to have Power Pivot, it's available mainly for enterprise subscriptions. You may check is it available for your one or not here https://support.office.com/en-us/article/Where-is-Power-Pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b.

As for loading to data model you most probably use Power Query (aka Get&Transform), these are different tools. It loads data to data model which is available for any version (any recent) of Excel, you only don't have Power Pivot to work with data model directly.