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...

  1. Open the Chapter 8 Power Pivot Excel workbook.
  2. Save a copy of the file as the Crash_Data_PowerPivot_SSAS workbook, 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.
  3. Open SQL Server Management Studio and connect to your tabular instance. Expand the Server menu to see the folders.
  4. Right-click on Databases to bring up the menu window, ...

Get Tabular Modeling with SQL Server 2016 Analysis Services Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.