Dataset Types

• 2023-08-21
• Morten Lønskov

Applies to:

• ✔ Desktop Edition
• ✔ Business Edition
• ✔ Enterprise Edition
• ✔Tabular Editor 2.x
• ✔Tabular Editor 3.x

Tabular Editor can work with several different dataset types. Bellow is an overview of which dataset types work with Tabular Editor and the capabilities that can be used with each dataset type.

Dataset Type	Import	Direct Lake (Standalone)	.pbix	.pbip
Connect in Tabular Editor	✔️	✔️	✔️	✔️
Create new dataset	✔️	❌	✔️	✔️
Write Measures	✔️	✔️	✔️	✔️
Create & Edit Tables	✔️	✔️1	❌	✔️
Create & Edit Partitions	✔️	✔️1	❌	✔️
Create & Edit Columns	✔️	✔️1	✔️	✔️
Create & Edit Calculated Tables	✔️	❌	✔️	✔️
Create & Edit Calculated Columns	✔️	❌	✔️	✔️
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 Diagrams2	✔️	✔️	✔️	✔️
Use Preview Data2	✔️	✔️	✔️	✔️
Use Pivot Grids2	✔️	✔️	✔️	✔️
Use DAX Queries2	✔️	✔️	✔️	✔️
Use DAX Debugger2	✔️	✔️	✔️	✔️
Use Vertipac Analyzer2	✔️	✔️	✔️	✔️
Process Model and Tables2	✔️	N/A	❌	❌
Delete Objects	✔️	✔️	✔️	✔️

Legend:

• ✔️: Supported
• ❌: Unsupported

1 - The table partition must be an Entity Partition to work correctly.

2 - Tabular Editor 3 features only. Operations performed through the XMLA endpoint requires a Business or Enterprise license. More information.

Unsupported datasets

The following datasets 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.
• Datasets with Push data.
• Datasets stored in Power BI My Workspace.
• Direct Lake Default Datasets. (It is possible to connect to a default dataset, but it is not possible to change it through the XMLA endpoint)
• Excel workbook datasets.