Mei - it appears to me that you are trying to restore backup on Analysis Services server that is installed as MOLAP server and not as "SharePoint integrated mode" (or "PowerPivot for SharePoint") server. You cannot do that. You are able to restore PowerPivot internal backup just to SSAS server that was installed in SharePoint integrated mode. For SSAS server DemploymentMode parameter is set in file "c:\Program Files\Microsoft SQL Server\MSAS10_50.PowerPivot\OLAP\Config\msmdsrv.ini" (default location)
Latest Posts
- The ALL() Function in DAX
- Power Pivot Crashes–Another Update from Seattle
- The Latest and Best Way to Catch/Capture/Inspect Slicer Selections
- Mighty Morphing Pivot Tables or: How I learned to automatically change hierarchy levels on rows
- 5 Useful Data Analysis Expressions (DAX) Functions for Beginners
- Handling Missing Members In The CubeSet() Function With Power Pivot
- Compare equivalent periods in DAX
- DAX Time Intelligence for Beginners
- How Many Working Days Has An Employee Been Off Work?
- How to Document DAX Measures in Excel
Most Popular
- List of PowerPivot DAX functions with description
- Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)
- DAX cheat sheet
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- How to install PowerPivot for Excel and list of know issues
- List of suggested datasets to test PowerPivot
- PowerPivot DAX function list with samples
- Q: How can I check what version of PowerPivot for Excel is installed on my machine?