Restore from Power Pivot

You can use the Restore from Power Pivot feature in SQL Server Management Studio to create a new Tabular model database on an Analysis Services instance (running in Tabular mode), or restore to an existing database from a Power Pivot workbook (.xlsx).


The Import from Power Pivot project template in SQL Server Data Tools provides similar functionality. For more information, see Import from Power Pivot (SSAS Tabular).

When using Restore from Power Pivot, keep the following in mind:

  • In order to use Restore from Power Pivot, you must be logged on as a member of the Server Administrators role on the Analysis Services instance.

  • The Analysis Services instance service account must have Read permissions on the workbook file you are restoring from.

  • By default, when you restore a database from Power Pivot, the Tabular model database Data Source Impersonation Info property is set to Default, which specifies the Analysis Services instance service account. It is recommended you change the impersonation credentials to a Windows user account in Database Properties. For more information, see Impersonation (SSAS Tabular).

  • Data in the Power Pivot data model will be copied into an existing or new Tabular model database on the Analysis Services instance. If your Power Pivot workbook contains linked tables, they will be recreated as a table without a data source, similar to a table created using Paste To New table.

To Restore from Power Pivot

  1. In SSMS, in the Active Directory instance you want to restore to, right click Databases, and then click Restore from Power Pivot.

  2. In the Restore from Power Pivot dialog box, in Restore Source, in Backup file, click Browse, and then select an .abf or .xslx file to restore from.

  3. In Restore Target, in Restore database, type a name for a new database or for an existing database. If you do not specify a name, the name of the workbook is used.

  4. In Storage location, click Browse, and then select a location to store the database.

  5. In Options, leave Include security information checked. When restoring from a Power Pivot workbook, this setting does not apply.

See Also

Tabular Model Databases (SSAS Tabular)
Import from Power Pivot (SSAS Tabular)