Power Pivot and Power View 'Data Model is damaged'

I've installed Office 365 Pro Plus and enabled the add-ins for Power View and Power Pivot.

Every time I want to use Power Pivot > Manage or Add to Data Model; or use the Power View button, the message "We couldn't load the Data Model. This may because the data model in this workbook is damaged'.

Exception from HRESULT: 0X800A03EC

I am local admin on my machine. I have 'run as administrator' with no change to issues.

The data I am testing was created in Excel 2013 so is compatible. I have tried other data; and have also got everything (including the add-ins) on a virtual desktop on my PC.

I have run Office365 repair tool and FixIT, PowerPivot repair tool and FixIT, Power View repair tool and FixIT.

I have uninstalled and reinstalled Office in its entirety 3 times today.

I have uninstalled and reinstalled Silverlight each time I uninstalled office.

I have also removed registry keys as described in other blogs for the Add-ins *Office>15.0.

Both my local and virtual machines have SQL 2012 installed (management studio only, not SSAS/SSRS/SSIS).

I am perplexed as to what else to do.

All assistance appreciated



  • Edited by modz21 Thursday, November 07, 2013 2:36 AM
November 7th, 2013 5:07am

Hi,

The issue may be caused by the SQL Server Analysis Services (Tabular) services,but I notice that you did not have SSAS/SSRS/SSIS.

Thus,in this circumstance, the reason for this error is by design and caused by modified user permissions.

On Windows Vista and Windows 7, the PowerPivot add-in requires the user to have permission for "SeIncreaseWorkingSetPrivilege" which is policy Increase a process working set.

This policy setting determines which users can increase or decrease the size of a process's working set. The working set of a process is the set of memory pages currently visible to the process in physical RAM memory.
These pages are resident and available for an application to use without triggering a page fault. The minimum and maximum working set sizes affect the virtual memory paging behavior of a process.

For more detail information, please refer to the following link:

http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2013/08/27/powerpivot-for-excel-2013-error-when-opening-the-manage-window-quot-we-couldn-t-load-the-data-model-this-may-be-because-the-data-model-in-this-workgroup-is-damaged-quot.aspx

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
November 8th, 2013 5:42am

Thanks @George Zhao

I've checked this parameter and it is set to Users. I added my username in addition to see if that made any change but unfortunately not.

I should've mentioned I'm running Win8 Enterprise.

Thanks

November 8th, 2013 5:53am

Hi,

As you above said, I need more information to do reseach. Could your use process monitor(http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx) to select a log and share to me?

I could appreciate it if you could do this.

Regards,

 

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
November 8th, 2013 10:59am

Thanks George for your perseverance.

https://dl.dropboxusercontent.com/u/78347809/Logfile.PML

From a brief look at the log file I have run it appears there are registry key issues. I'll keep researching at this end also.

Thanks

November 10th, 2013 8:29pm

Hi Sir,

Thanks for your respond, as the log is 114M large,I need sometimes to download and analyse it. I'll give your reply later if I have some sulutions.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
November 11th, 2013 12:30am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics