Semantic Model Types
Tabular Editor can work with several different model types. Below is an overview of which model types work with Tabular Editor and the capabilities that can be used with each model type.
| Model Type | Import | Direct Query | Direct Lake on OneLake | Direct Lake on SQL | .pbix | .pbip |
|---|---|---|---|---|---|---|
| Connect in Tabular Editor | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | |
| Create new model | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Write Measures | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Create & Edit Tables | ✔️ | ✔️ | ✔️1 | ✔️1 | ✔️ | ✔️ |
| Create & Edit Partitions | ✔️ | ✔️ | ✔️1 | ✔️1 | ✔️ | ✔️ |
| Create & Edit Columns | ✔️ | ✔️ | ✔️1 | ✔️1 | ✔️ | ✔️ |
| Create & Edit Calculated Tables | ✔️ | ✔️ | ✔️2 | ✔️ | ✔️ | ✔️ |
| Create & Edit Calculated Columns | ✔️ | ✔️ | ✔️2 | ✔️ | ✔️ | ✔️ |
| Create & Edit Calculation Groups | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | |
| Create & Edit Relationships | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | |
| Create & Edit Roles | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Create & Edit Perspectives | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Create & Edit Translations | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Use Best Practice Analyzer | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | |
| Edit All TOM properties | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Create Diagrams3 | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Use Preview Data3 | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Use Pivot Grids3 | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Use DAX Queries3 | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Use DAX Debugger3 | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Use Vertipac Analyzer3 | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Process Model and Tables3 | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Delete Objects | ✔️ | ✔️ | ✔️ | ✔️ |
Legend:
- ✔️: Supported
- ❌: Unsupported
1 - The table partition must be an Entity Partition to work correctly and Direct Lake models can only have one partition. 2 - Calculated Tables and Columns cannot refer to Direct Lake on OneLake tables or columns.
3 - Tabular Editor 3 features only. Operations performed through the XMLA endpoint requires a Business or Enterprise license. More information.
Note
The June 2025 Release of Power BI Desktop all modeling limitations for third party tools where lifted. Prior to that various modeling operations where not supported. See Power BI Desktop Limitations
Tip
For further details on restrictions on Direct Lake models refer to Microsoft's Direct Lake documentation
Unsupported Semantic Model types
The following semantic model types are unsupported, as they don't support XMLA write operations.
- Reports based on a live connection to an Azure Analysis Services or SQL Server Analysis Services model.
- Reports based on a live connection to a Power BI dataset.
- Models with Push data.
- Models stored in Power BI My Workspace.
- Models stored in Power BI Pro Workspace.
- Direct Lake Default Semantic Models. (It is possible to connect to a default dataset, but it is not possible to change it through the XMLA endpoint)
- Excel workbook Semantic Models.