
Course introduction
Why should you be interested in using Tabular Editor?
In this lecture we talk about some of the differences between v2 and v3.
In this lecture we talk about the commercial nature of Tabular Editor 3
In this discussion we talk briefly about what a tabular model is
In this lecture we briefly talk about Tabular Object Model
A brief description of the Contoso database used in this course
An overview of Tabular Editor
In this lecture we talk about setting some important preferences for Tabular Editor, for this course.
In this lecture we demonstrate how to configure Tabular Editor exactly how you want it and then restore it back to its default settings
The DAX Editor is the main piece of functionality in Tabular Editor. We start a discussion of this in this lecture.
Part 2 of our discussion of The DAX Editor
Part 3 of our discussion of The DAX Editor
In this lecture we talk about Tabular Editor's ability to preview data and generate a pivot grid.
In this lecture we talk about how to create DAX queries, much like you would do in DAX Studio.
Here we discuss creating diagrams in Tabular Editor
In this lecture we start getting you acquainted with C# scripting in Tabular Editor
In this lecture we introduce Calculation Groups in Tabular Editor
In this lecture we discuss the Best Practices Analyzer
In this lecture we briefly discuss the Vertipaq Analyzer
This lecture shows you how to select multiple measures, script them all at once, make some changes and then apply and sync those changes to Power BI.
In this lecture we talk about how to format values
A very nice feature in Tabular Editor is the ability to search. We discuss that in this lecture.
Every Power BI wants to version control their work. Tabular Editor gets you part of the way there.
We finally now have a DAX debugger. We cover how this amazing addition to Tabular Editor works.
We finally now have a DAX debugger. We cover how this amazing addition to Tabular Editor works.
v3.0.6 was released on 17-June 2021. Changes are mostly centered around executing DAX queries.
Lots of great new features in this release including, for the first time ever, a DAX debugger! We cover all the new features in this lecture.
Lots of great new features in this release including, for the first time ever, a DAX debugger! We cover all the new features in this lecture.
Practice #1
Practice #2
Practice #3
Practice 4
Practice #5
Practice #6
Practice #7
Practice #8
Tabular Editor is an editor alternative to SSDT or Power BI for authoring Tabular models for Analysis Services, with or without an Analysis Server server running.
Tabular Editor 2 is an open source project that can edit a BIM file without accessing any data. This offline capability makes any change very quick when applying the change to the BIM file, especially when you manipulate and manage measures, calculated columns, display folders, perspectives and translations.
Tabular Editor 3 is a wonderful evolution of the popular community tool that is Tabular Editor 2. It is very lightweight, fast, intuitive and already in use by thousands of BI professionals worldwide. It includes premium features not found in Tabular Editor 2 that will make your life as a Tabular Model author even better! It has a Visual Studio like IDE, theming (dark mode!!), high-DPI and multi-monitor support, full and sophisticated auto completion, formatting, data preview, pivot grids, refactoring and a superb DAX editor, and so much more. You will never want to write DAX using any other editor ever again.
When Tabular Editor 3 is connected to Analysis Services or the XMLA endpoint of Power BI Premium, you will also be able to work with the data in your model. You can also initiate and monitor data refresh operations from within Tabular Editor. Testing and verifying that your model works the way you want it to has never been easier or more efficient.
Tabular Editor supports the compatibility level 1200 or newer (JSON format), including the 1500 required by calculation groups.