When trying to restore a PP 2013 xlsx made in Office 2013 we get an error:
"A connection corresponding to the embedded PowerPivot data was not found in the Excel Workbook."
This makes no sense, since the connection is a SQL Server database. It works to build out the PP itself, so why the error?
If we manually extract the data file from the xlsx, save as an abf and then try and restore normally we get this error :
"backup store version 150 is not supported."
If the exact same PP was built in Office 2010, with the PowerPivot 2012 plug-in, everything works as normal. So this speaks to an issue with Office 2013 and its built in PP plug-in