Share via


Tabular Model Databases (SSAS Tabular)

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.

Benefits of Using Tabular Model Databases

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

Tabular Model Roles (SSAS Tabular)

Tabular Model Partitions (SSAS Tabular)

Configure In-Memory or DirectQuery Access for a Tabular Model Database

Connect to a Tabular Model Database (SSAS)

Restore from PowerPivot

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