
Install tabular editor three from the website, select 64-bit or 32-bit installer, or tabular editor two, then activate the license and launch from start menu or Power BI Desktop.
Explore the Tabular Editor 3 UI, learn to customize panes like expression editor, term explorer, and properties pane, and master layout, ribbons, and preferences for efficient Power BI modeling.
Master the tabular object model (tom) as the foundation of Power BI and Analysis Services data models, defining tables, columns, relationships, measures, security, and the model dot BIM file.
Discover how to serialize Power BI data models for CI/CD by exporting the model BIM, datasets, and visuals into a Power BI project, enabling git-based collaboration and Azure DevOps workflows.
Explore the preview data feature in Tabular Editor 3 for Power BI, previewing underlying table data from Analysis Services, applying sorts, filters, and best fit widths.
Explore the diagram view in Tabular Editor 3 to map and edit table relationships for Power BI and Analysis Services, using drag-and-drop, auto arrange, and save diagrams.
Learn to use detail rows expression to customize drillthrough for measures and tables with Tabular Editor, including editing DAX, using Excel, and building tailored columns from related tables.
Explore the dax query feature in Tabular Editor for Power BI, learning how to evaluate data, define measures, and script tables and columns to preview and shape model results.
Learn to load data into a Power BI data model by executing DAX queries against analysis services. Embed measures with the define keyword and load the table via Power Query.
Learn to reference objects in the data model by chaining from the model to tables, then to measures and columns in tabular editor.
Add new measures and calculated columns to the data model using C# in Visual Studio. Define measure objects, DAX expressions, and display folders, then save changes to refresh metadata.
Refresh the data model with C# by building a static method to refresh a table or the whole model, using a refresh type enum and saving changes.
Learn to create measures from selected numeric columns in Tabular Editor 3, filtering by data type, iterating with a for-each loop, and setting measure properties such as format and description.
Format Dax code in Tabular Editor by batch formatting all measures, enabling multiline formatting and spacing options. Use a C# script to set all columns' summarize by to none.
Explore vertipaq analyzer to optimize your data model by collecting ram usage, cardinality, relationships, partitions, and the segments inside those partitions, then view summary data and compatibility details.
Examines the trade-offs of the attribute hierarchy size column and shows how disabling IsAvailableInMDX affects DAX performance, metadata, and Excel usability.
Optimize your Power BI data model by using Vertipaq analyzer to prune high-cardinality columns, compare import versus measures, and split date-time columns to reduce RAM while maintaining analytical accuracy.
In this course you will learn how to use Tabular Editor 3, the best external tool for Power BI and SQL Server Analysis Services.
Learning TE3 is an essential skill for any serious model developer. It lets you build models far more efficiently and make changes directly to a live database, without needing the PBIX file or a Visual Studio project. The result is dramatically faster development.
What you can do with Tabular Editor 3
Develop your data model faster, creating Measures, Columns, and Tables and applying them in a single commit, instead of waiting for Power BI Desktop to process each change one by one
Write DAX queries to investigate your data, visualize the results, and debug your model
Secure your model with Row Level and Object Level Security using roles
Build Calculation Groups to cut down the number of measures and measure variations you have to maintain, then script them and deploy the same logic to a completely different model
Automate repetitive work with C# scripts that iterate over the Tabular Object Model and perform actions in bulk
Analyze and optimize model size, memory, and performance using Vertipaq Analyzer
Run process commands on individual Tabular objects such as Tables and Partitions, modify Incremental Refresh policies in the Power BI Service, and process partitions directly
C# scripting for Tabular models
This course also includes a practical C# scripting section focused on what you actually need to automate your modeling work, covering data types, variables, libraries, methods, functions, and LINQ as they apply to Tabular Editor. The goal is not to make you a C# programmer, but to give you enough working knowledge to confidently script and automate against your Power BI and Analysis Services models.
Why it matters
This is just the tip of the iceberg, and there is much more you can do with TE3. When it comes to saving development effort, it is an absolute beast, and by the end of this course you will know how to put it to work.
What this course does not cover
To keep this course focused and set honest expectations:
This is not a beginner Power BI or DAX course. You should already know the basics.
This course teaches C# only as far as it applies to Tabular Editor automation, not general-purpose programming.
This is not a data visualization or report-building course.
I am excited to see you inside the course and help you master Tabular Editor 3.