I can't find clear documentation on this so looking for any clarification or confirmation. Have SharePoint 2013 on prem using PowerPivot and wants to move the instance to another SQL server.
My understanding would be setup the SQL instance and PowerPivot install, stop the PowerPivot service instance in SharePoint, backup/restore the databases, run the PowerPivot config wizard to point to the new SQL instance, start the service instance. Is that right? Do the datasources in the Excel workbooks need to be updated too? Or what's the proper method? Thanks!