Analysis Services (Azure, SQL Server, SSAS) Tabular

Applies to: Dataedo 24.x (current) versions, Article available also for: 10.x, 23.x

Documenting and cataloging Analysis Services Tabular

This article describes Dataeedo connector to Analysis Services Tabular Model. For Analysis Services Multidimensional (including cubes and dimensions) see this article.

Catalog and documentation

Dataedo imports Tables and Data sources, retrieves relationships between tables, and automatically builds a column-level lineage.


Dataedo imports tables and columns. Metadata such as data type, identity, and nullable attributes are also imported for these objects. Image title


Dataedo imports and represents relationships between tables based on keys. Image title

Data Lineage

The foundation for building lineage in the Tabular connector is the Linked Source. When importing a Tabular server, Dataedo retrieves Data Sources, which in Dataedo are named Linked Source. Dataedo connects existing documentation with Data Sources. If a matching connection is found, lineage will be built based on it. You can read more about linked sources in this article.

Column level lineage is built between a source table and a table in Analysis Services Tables and is created at the import stage. Image title


The script that creates the table is available in the Desktop version of Dataedo Image title

Data Sources

Dataedo imports informations about connections defined in the model. Imports both available connection types in Tabular: -Provider Data Source (Legacy type) -Structured Data Source

Image title

Linked source is assigned to a table that is based on a given connection. Linked source assigned to a Table is visible in the Metadata & Settings tab of the Table, in the Desktop version of Dataedo.

Image title

Supported versions

  • SQL Analysis Services (SSAS): 2016, 2017, 2019
  • Azure Analysis Services
  • Power BI Premium

Data profiling

Datedo does not support data profiling in SSAS Tabular.


Following model elements currently are not supported:

  • Hierarchies
  • Partitions
  • Roles

Learn more


Imported metadata

Dataedo reads following metadata from SSAS Tabular.

Imported Editable
    Data type with length
    Identity (is identity on)
    Primary keys
    Foreign keys
  Calculated Columns
    Data type with length
    Data type with length
    Data type with length
Found issue with this article? Comment below
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.