O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required