Moving Power Pivot to SSAS via Management Studio
Once you have a developed Power Pivot solution that you would like to move to SSAS, you can save a copy of your Excel workbook and place it in the SSAS backup folder location. Then use the Excel file as the basis for the SSAS model.
How to do it...
- Open the Chapter 8 Power Pivot Excel workbook.
- Save a copy of the file as the
Crash_Data_PowerPivot_SSASworkbook, and then copy or move the file to the backup location of your SSAS server. In this example, the folder is
c:\Program Files\Microsoft SQL Server\MSAS13.MSSQLSERVER\OLAP\Backup.
- Open SQL Server Management Studio and connect to your tabular instance. Expand the Server menu to see the folders.
- Right-click on Databases to bring up the menu window, ...