- Download Tabular Editor 3.0.4
- Download Tabular Editor 3.0.4 (64 bit)
If you haven't used Tabular Editor 3 before, you are eligible to a 30 day trial, which can be requested after installation. You can also purchase a license.
NOTE: If you previously installed one of the BETA builds, you will have to manually uninstall that before installing this new version.
Coming from Tabular Editor 2.x?
Watch this video to get an idea of the new features in Tabular Editor 3.
Tabular Editor 3 major features overview:
- Fully customizable IDE, with multi-monitor, Hi-DPI support and themes
- New powerful DAX code editor with auto-complete, syntax checking, code folding and much, much more
- *Workspace mode, allowing you to save your changes to disk and synchronise model metadata to Analysis Services simultaneously
- *Preview table data with infinite scrolling, create PivotGrids or write DAX queries to browse the model or test calculation logic
- *Update Table Schemas on both Provider and Structured Data Sources (yes, even for M queries!)
- *Schedule data refreshes
- Create data model diagrams
- Create DAX scripts that allow you to edit multiple measures or other calculated objects in a single document
- Record C# scripts and save as macros (formerly known as "Custom Actions")
- VertiPaq Analyzer integration
*=Only while connected to an instance of Analysis Services or Power BI
Known issues
- Table Import Wizard didn't make it to this release due to some high-priority bugs that had to be fixed. It will be available ASAP! As a work around, simply create a new table and specify the partition query (SQL or M). Then, right-click the table and choose "Update Table Schema..." to import columns.
- See roadmap for more information.
Bugfixes in 3.0.4:
- Refreshing the Best Practice Analyzer no longer causes a crash.
New features in 3.0.3:
- Right-clicking on an item in the Processing View now lets you requeue that item or, if the item represents a single table, opens a data preview of that table.
Bugfixes in 3.0.3:
- When the semantic analyzer detects an error on a calculated column/calculated table, it no longer modifies the columns on that table (this was previously causing relationships to be dropped in some circumstances)
- Fixed an issue with enabled-state of certain controls on the Find/Replace dialog
- Several bugfixes based on telemetry and error reports, such as:
- Copy/pasting columns with lineage tags now works
- Pasting a table over an existing one when the table is renamed no longer causes a crash
- "Revert" button now reconnects to AS before refresing the local TOM, instead of causing a crash
- Right-clicking in the property grid while it is empty no longer causes a crash
- And many, many others...
- Fixed MRUs not being properly saved for the "Server" dropdown
- Fixed several issues with the Workspace Mode not properly loading data source override values from the User Options file. See #28.
- Fixed and improved several "phantom" DAX semantic errors (support for ROLLUPADDISSUBTOTAL, COUNTROWS with 0 arguments, etc.)
- Improved autocomplete / calltips for several DAX functions (TOPN, TOPNPERLEVEL, interval parameter for DATEADD/DATESINPERIOD/PARALLELPERIOD), after RETURN keyword, etc.
New features in 3.0.2:
- You can now change your license key from the Help > About Tabular Editor dialog (option available only when no model is currently loaded).
- Added a "Revert" button in the main toolbar and File menu (you may need to restore the Default workspace to see it). When clicked, this button reloads the TOM from the connected source (Power BI model or Analysis Services database). It can be used to manually synchronize changes between the two, if the automatic option is disabled under Tools > Preferences.
Bugfixes in 3.0.2:
- DAX Editor support for the TEXT / INTEGER keywords in the PATHITEM / PATHITEMREVERSE DAX functions.
- DAX Editor preferences are now persisted between sessions (see #23)
- Various DAX Editor autocomplete / calltip improvements.
- Fixed issue #14 (object errors not shown in TOM Explorer)
- Support for KMeansClustering DAX extension function.
- Fixed bug with DAX Parser reporting errors on comparing a value with BLANK() in the SWITCH function.
- A few minor visual updates
- Fixed a crash that would occur when trying to execute a DAX script that edits/adds objects that are unsupported on a Power BI Desktop file (for example, we cannot yet add calculated tables or calculated columns through external tools)
- DetailRowsExpressions are now editable on measures when connected to a Power BI Desktop file.
- Fixed a bug with SciLexer.dll that caused a crash immediately upon startup in some cases.
- Column names in the DAX query are now shown as-is (no adding of spaces before capital letters
New features in 3.0.1:
(The list below compares Tabular Editor 3.0.1 with the previous beta release)
- Updated EULA and added ThirdPartyNotices.txt to installer.
- Schema Compare now also works with Provider (Legacy) Data Sources and Query partitions
- The first time you use the "Format DAX" button, Tabular Editor will ask for your consent to send DAX code to the www.daxformatter.com web service (an upcoming version of Tabular Editor 3 will feature offline DAX code formatting, making this consent obsolete).
- Improved some text strings on the Activation Wizard, and allow entering a new license key if the current license has expired.
- Added Connection String editor to property grid
- Added preferences for globally ignoring certain types of schema differences under Tools > Preferences > Schema Compare.