Creating your first Analysis Services Model¶
Applies to: ❌
Desktop Edition, ✔Business Edition, ✔Enterprise Edition
This page walks you through the process of creating a new Analysis Services tabular model from scratch using Tabular Editor 3.
Tabular Editor 3 Desktop Edition does not have any support for Analysis Services tabular models.
Creating a new model¶
From the File menu, choose New > Model… or hit
Provide a name for your model or use the default value. Then, choose the compatibility level depending on which version of Analysis Services you are targetting. Your options are the following:
1200 (Works with SQL Server 2016 or newer, and Azure Analysis Services)
1400 (Works with SQL Server 2017 or newer, and Azure Analysis Services)
1500 (Works with SQL Server 2019 or Azure Analysis Services)
For the best development experience, check the “Use workspace database” option. This requires that you have an instance of Analysis Services available on which your workspace database will be deployed. This could be a local or a remote instance of SQL Server Analysis Services or it could be an instance of Azure Analysis Services. When you click OK, you will be prompted to enter the connection string for the Analysis Services instance in which you want the workspace database created.
With a workspace database, you can validate Power Query (M expressions) and import table schema from Power Query expressions. You can also refresh and query data in the workspace database, making it easier to debug and test your DAX expressions.