Tabular Model Databases (SSAS Tabular)


Applies To: SQL Server 2016

A tabular model database is an Analysis Services database that you create in SQL Server Data Tools (SSDT) using the Analysis Services Tabular model project template, where tables and relationships are the primary structures for representing data.

Tabular model databases are easier to build than multidimensional databases, particularly if you have a relational database background. Otherwise, administrative tasks are similar if not identical to database administration of a multidimensional database. The same tools and approaches apply.

Tabular Model Solutions (SSAS Tabular)

Tabular Model Data Access

Process Database, Table, or Partition (Analysis Services)

Tabular Model Roles (SSAS Tabular)

Tabular Model Partitions (SSAS Tabular)

DirectQuery Mode (SSAS Tabular)

Connect to a Tabular Model Database (SSAS)

Restore from Power Pivot

Move an Analysis Services Database

Synchronize Analysis Services Databases

Switch an Analysis Services database between ReadOnly and ReadWrite modes

Modify or Delete an Analysis Services Database

Document and Script an Analysis Services Database

Backup and Restore of Analysis Services Databases

Attach and Detach Analysis Services Databases

Community Additions