Analysis Services (Azure, SQL Server, SSAS) Tabular

Applies to: Dataedo 23.x versions, Article available also for: 24.x (current), 10.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 24.x (current).

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

Supported versions

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

Supported schema elements and metadata

  • Tables
    • Columns
      • Data type with length
      • Identity (is identity on)
      • Nullable
    • Calculated Columns
      • Data type with length
      • Calculate Formula
    • Measures
      • Data type with length
      • Calculation formula
    • KPIs
      • Data type with length
      • Condition
  • Primary keys
    • Columns
  • Foreign keys
    • Columns

Data profiling

Datedo does not support data profiling in SSAS Tabular.

Limitations

Following model elements currently are not supported:

  • Hierarchies
  • Partitions
  • Roles

Learn more