📒
BI & Other Tech Notes
  • About
  • Power BI
    • Analysis Services
      • TOM Compatibility Levels
      • List new features in TOM library
    • XMLA Endpoint
      • Deploy through XMLA Endpoint with TOM
    • How-To Articles
      • Download PBIX for Report created in Service
    • Power BI Docs
    • Power BI REST API
    • pbi-tools
Powered by GitBook
On this page
  • API Changes in 19.65.7 - 6-Jul-2023
  • API Changes in 19.65.4 - 8-Jun-2023
  • API Changes in 19.64 - 4-May-2023
  • API Changes in 19.61 - 6-Apr-2023
  • 1604 (new in 19.60 - 16-Mar-2023)
  • API Changes in 19.60
  • 1603 (new in 19.57 - 9-Feb-2023)
  • API Changes in 19.55 - 11-Jan-2022
  • API Changes in 19.54 - 8-Dec-2022
  • API Changes in 19.52 - 10-Nov-2022
  • API Changes in 19.51 - 6-Oct-2022
  • 1601 (new in 19.49 - 19-Sep-2022)
  • API Changes in 19.48 - 15-Aug-2022
  • 1572 (new in 19.46 - 11-Jul-2022)
  • 1571 (new in 19.42 - 20-Jun-2022)
  • 1570 (new in 19.42 - 20-Jun-2022)
  • API Changes in 19.39 - 13-Apr-2022
  • 1569 (new in 19.36 - 01-Mar-2022)
  • 1568 (new in 19.36 - 01-Mar-2022)
  • 1567 (new in 19.34 - 10-Feb-2022)
  • 1566 (new in 19.27 - 10-Nov-2021)
  • 1565 (new in 19.26 - 08-Sep-2021)
  • 1564 (new in 19.22 - 02-Jun-2021)
  • 1563 (new in 19.20 - 07-Apr-2021)
  • 1562 (new in 19.16 - 15-Jan-2021)
  • 1561 (new in 19.14 - 08-Dec-202)
  • 1560 (new in 19.12 - 12-Oct-2020)
  • 1550 (new in 19.9 - 10-Aug-2020)
  • 1545 (new 19.6 - 14-Jul-2020)
  • 1540 (new 19.4 - 16-Jun-2020)
  • 1535 (new in 19.2 - 01-Jun-2020)
  • 1520 (max level in 18.4)
  • 1510
  • 1500
  • 1480
  • 1475
  • 1470
  • 1465
  • 1460
  • 1455
  • 1450
  • Earlier Versions

Was this helpful?

Edit on GitHub
  1. Power BI
  2. Analysis Services

TOM Compatibility Levels

The missing documentation.

PreviousAnalysis ServicesNextList new features in TOM library

Last updated 1 year ago

Was this helpful?

Ever since the convergence of Analysis Services (Tabular) and Power BI (Premium) has started, the Analysis Services API surface has evolved rapidly. New versions of the are being released frequently, and new Power BI (Premium) features introduce new TOM Compatibility Levels which must be configured at the database in order to enable certain features in the underlying engine.

However, official documentation of those feature sets and the corresponding compatibility levels and NuGet versions is very sparse.

Using the reflection approach described , this page provides "The Missing Documentation" - a chronological listing of TOM features by compatibility level. Major features are annotated with related articles and blog posts.

API Changes in 19.65.7 - 6-Jul-2023

  • Release of []

No changes in public API

API Changes in 19.65.4 - 8-Jun-2023

No changes in public API

API Changes in 19.64 - 4-May-2023

  • Release of []

  • REMOVED: CalculationGroup.DefaultExpression property (Preview)

  • REMOVED: CalculationExpression class (Preview)

  • ADDED: CalculationGroupSelectionMode enum (Preview)

  • ADDED: CalculationGroupExpression class (Preview)

  • ADDED: CalculationGroup.MultiSelectionExpression property (Preview)

  • ADDED: CalculationGroup.NoSelectionExpression property (Preview)

API Changes in 19.61 - 6-Apr-2023

  • NEW MetadataObject types:

    • Calendar (Preview)

    • TimeUnitColumnAssociation (Preview)

    • CalendarColumnReference (Preview)

  • ADDED: TimeUnit enum (Preview)

1604 (new in 19.60 - 16-Mar-2023)

API Changes in 19.60

1603 (new in 19.57 - 9-Feb-2023)

API Changes in 19.55 - 11-Jan-2022

No changes in public API

API Changes in 19.54 - 8-Dec-2022

No changes in public API

API Changes in 19.52 - 10-Nov-2022

  • The execution flow of ApplyRefreshPolicy is the same as the flow that is triggered by a call to RequestRefresh, followed by a call to Model.SaveChanges.

  • The execution flow includes:

    • Calculating the expected partitioning scheme based on the effective date.

    • Comparing the expected partitioning scheme to the existing set of partitions and issue the needed changes to move to the expected scheme [dropping, creating, and merging partitions as needed].

    • Refresh the newly created partitions as well as the existing partitions in the incremental window.

  • The only difference between the ApplyRefreshPolicy and the combination of RequestRefresh+SaveChanges is ApplyRefreshPolicy enables advanced options that are not available otherwise.

  • It is recommended to use ApplyRefreshPolicy when you want to use a single API call, especially with advanced options.

  • It is recommended to use the combination of RequestRefresh + SaveChanges when you want to combine the operation with additional authoring calls in the model before the call to SaveChanges.

API Changes in 19.51 - 6-Oct-2022

No changes in public API

1601 (new in 19.49 - 19-Sep-2022)

API Changes in 19.48 - 15-Aug-2022

1572 (new in 19.46 - 11-Jul-2022)

1571 (new in 19.42 - 20-Jun-2022)

1570 (new in 19.42 - 20-Jun-2022)

API Changes in 19.39 - 13-Apr-2022

    • DAXEvaluationLog = 135 Output of EvaluateAndLog function.

    • public AsAzureRedirection AsAzureRedirection { get; }

1569 (new in 19.36 - 01-Mar-2022)

1568 (new in 19.36 - 01-Mar-2022)

1567 (new in 19.34 - 10-Feb-2022)

1566 (new in 19.27 - 10-Nov-2021)

1565 (new in 19.26 - 08-Sep-2021)

Hybrid Tables in PBI Premium

API Changes

    • RefreshPolicyMode.Import: Creates import partitions during incremental refresh.

    • RefreshPolicyMode.Hybrid: Creates import and DirectQuery partitions during incremental refresh.

1564 (new in 19.22 - 02-Jun-2021)

1563 (new in 19.20 - 07-Apr-2021)

1562 (new in 19.16 - 15-Jan-2021)

Auto Aggregations

API Changes

1561 (new in 19.14 - 08-Dec-202)

1560 (new in 19.12 - 12-Oct-2020)

1550 (new in 19.9 - 10-Aug-2020)

  • SourceLineageTag (Column, Hierarchy, Level, Measure, NamedExpression, Table): A tag that represents the lineage of the source for the object.

1545 (new 19.6 - 14-Jul-2020)

1540 (new 19.4 - 16-Jun-2020)

  • LineageTag (Column, Hierarchy, Level, Measure, NamedExpression, Table): A tag that represents the lineage of the object.

1535 (new in 19.2 - 01-Jun-2020)

1520 (max level in 18.4)

1510

1500

1480

QueryGroups

1475

1470

Calculation Groups

API Changes

1465

"Enhanced Metadata Format"

API Changes

1460

1455

Dual Storage Mode

API Changes

1450

Incremental Refresh Policy (Import)

API Changes

Earlier Versions

  • 1100, 1103, 1200, 1400

Release of []

ADDED: (used with )

ADDED:

ADDED: : Create a script to export a database.

MetadataObject type: A tabular DataCoverageDefinition object. The expression defined on this object gives hint about the data in a partition.

: A reference to an optional DataCoverageDefinition that provides the hint regarding the data that is covered by the partition.

Remarks added to , :

Introduces FormatStringDefinition to measures. Previously, those only existed on .

: A reference to a FormatStringDefinition object owned by this Measure.

: Retrieves automatic aggregation recommendations from Analysis Services engine and applies changes to the model.

: Scripts out a given Tabular database into an ApplyAutomaticAggregations command.

: An indication whether the table is excluded from the automatic aggregations feature.

: An indication if the translation of the property had been changed.

: A reference to the NamedExpression where the parameter associated with the remote model.

: The parameter name defined in source model, applicable only for proxy model and empty for local model.

New value in

New property in

: Maximum degree of parallelism for query in formula engine

: Determines the max possible number of parallel tasks in data refresh, within the resource constraints of the hosting service.

ChangedProperties (, , , , , ): Represents an indication of a change to one of the object's properties.

: Disable auto exists behavior for SummarizeColumns.

(Enum)

: The data in this partition is populated by executing a query generated by the system.

: Represents a Partition that its data will be populated by executing a query generated by the system.

: Represents a Partition that its data will be populated by executing a query generated by the system.

: A boolean value that indicates whether the table is managed by the system. The system takes ownership of creation and deletion of such tables.

: No filtering will occur from either end of the relationship.

: Determines whether to discourage composite models.

: Client tools apply filters to this column using M parameter. The presence of this property indicates model owner allows Dax queries to override this parameter, and columns data type must match the type specified in the meta tag of the parameter.

: The string that has M attributes.

: The name of the Culture used for formatting during refresh through Mashup.

: DataSourceDefaultMaxConnections will be used for connections to a data source if MaxConnections is set to -1 on the data source object or if there is no corresponding data source object for the data source.

: The zero-based ordinal value associated with a Calculation Item.

: Gets the collection object of all querygroups in the current Model.

: QueryGroup associated with the expression.

: QueryGroup associated with the partition.

: A boolean value that indicates whether the table is excluded from model refresh. When this is true, a refresh operation on the model would not trigger a refresh on the partitions of the table if they were already processed.

: Controls whether this model allows data source variables to be overriden.

,

: The partition uses CalculationGroup as a source.

: Determines whether to discourage the implicit measures.

: Power BI V3 Data Sources support basic partition management operations.

: Determines whether measures can have the same names as any column in the model.

: Specifies the type of the linguistic metadata from the Content property. E.g. XML or JSON.

(Enum: GroupBy, Sum, Count, Min, Max): Specifies the Summarization type to be used by alternative sources' columns.

: Represents a AlternativeSource object. It is a child of either a Table or a Column object.

: Defines the AlternateOf reference source BaseTable or BaseColumn, and the Summarization.

: The ranking or precedence used to select the alternate source table in case more than one match is found.

: Allows support for dual mode of Import as well as DirectQuery.

: Specifies the type of data contained in the measure so that you can add custom behaviors based on measure type.

(Enum: Day, Month, Quarter, Year)

(Enum: Basic)

: The partition uses an M expression to retrieve the data. The partition ranges are auto created based on RefreshPolicy.

(Enum): DataSource format version in Power BI Service.

: Used by PBIX data source format conversion.

TOM client libraries
in this article
Article: Compatibility level for tabular models
TMDL Preview-3
NetCore
TMDL Preview-2
NetCore
TMDL Preview-1
NetCore
ModeType.DirectLake
Partition.Mode
EntityPartitionSource.SchemaName
JsonScripter.ScriptExport(Database)
DataCoverageDefinition
Partition.DataCoverageDefinition
Model.ApplyRefreshPolicies
Table.ApplyRefreshPolicy
Calculation Items
Measure.FormatStringDefinition
Model.ApplyAutomaticAggregations
JsonScripter.ScriptApplyAutomaticAggregations
Table.ExcludeFromAutomaticAggregations
ObjectTranslation.Altered
NamedExpression.ExpressionSource
NamedExpression.RemoteParameterName
TraceEventClass Enum
ConnectionInfo Class
Model.MaxParallelismPerQuery
Model.MaxParallelismPerRefresh
Column
Hierarchy
Level
Measure
Relationship
Table
Model.DisableAutoExists
https://powerbi.microsoft.com/blog/announcing-public-preview-of-hybrid-tables-in-power-bi-premium/
https://docs.microsoft.com/power-bi/connect-data/incremental-refresh-overview
https://docs.microsoft.com/power-bi/connect-data/incremental-refresh-xmla
RefreshPolicyMode
RefreshPolicy.Mode
AutomaticAggregationOptions
Model.AutomaticAggregationOptions
PartitionSourceType.Inferred
InferredPartitionSource
ParquetPartitionSource
https://powerbi.microsoft.com/blog/announcing-public-preview-of-automatic-aggregations/
https://aka.ms/AutomaticAggregations
https://docs.microsoft.com/power-bi/enterprise/aggregations-auto-configure
Table.SystemManaged
SecurityFilteringBehavior.None
Model.DiscourageCompositeModels
NamedExpression.ParameterValuesColumn
Model.MAttributes
NamedExpression.MAttributes
Model.SourceQueryCulture
Model.DataSourceDefaultMaxConnections
CalculationItem.Ordinal
Model.QueryGroups
NamedExpression.QueryGroup
Partition.QueryGroup
Table.ExcludeFromModelRefresh
Model.DataSourceVariablesOverrideBehavior
https://www.sqlbi.com/articles/introducing-calculation-groups/
https://www.sqlbi.com/calculation-groups/
https://docs.microsoft.com/analysis-services/tabular-models/calculation-groups
CalculationGroup
CalculationItem
Table.CalculationGroup
PartitionSourceType.CalculationGroup
Model.DiscourageImplicitMeasures
https://docs.microsoft.com/power-bi/connect-data/desktop-enhanced-dataset-metadata
https://powerbi.microsoft.com/blog/power-bi-september-2020-feature-summary/#Enhanced_Dataset_Metadata
https://powerbi.microsoft.com/blog/power-bi-desktop-march-2020-feature-summary/#_Enhanced_dataset_metadata
PowerBIDataSourceVersion.PowerBI_V3
Model.ForceUniqueNames
LinquisticMetadata.ContentType
SummarizationType
AlternateOf.Summarization
AlternateOf
Column.AlternateOf
Table.AlternateSourcePrecedence
https://docs.microsoft.com/power-bi/transform-model/desktop-storage-mode
ModeType.Dual
Measure.DataCategory
https://docs.microsoft.com/power-bi/connect-data/incremental-refresh-configure
https://powerbi.microsoft.com/blog/incremental-refresh-is-generally-available/
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
Table.RefreshPolicy
BasicRefreshPolicy
RefreshGranularityType
RefreshPolicyType
PartitionSourceType.PolicyRange
PolicyRangePartitionSource
PowerBIDataSourceVersion
Model.DefaultPowerBIDataSourceVersion