- Download Tabular Editor 3.0.6 (64 bit) (recommended)
- Download Tabular Editor 3.0.6
- Portable versions: x64, x86
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.
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.
Improvements in 3.0.6:
- Support for consultancy licenses. More details.
- DAX queries now display row counts and timings (see issue #10)
- DAX queries are now limited to 1000 rows by default, to prevent timeouts/memory issues. This limit can be changed in Tools > Preferences > Data Browsing > DAX Query.
- Columns in the DAX query results can now be sorted and filtered (local sorting/filtering only). See issue #60
- Data from grids (DAX query results, Table Preview, etc.) can now be copied to the clipboard
- When copying a DAX expression the syntax highlighting is now preserved on the clipboard. See issue #80.
- When adding a calculated table through a C# script expression, the semantic analyzer now immediately adds the calculated table columns to the table based on the DAX expression (instead of after script execution).
- Updated TOM client library to v. 19.22.0.1
- Portable versions (.zip) now available. Remember that you have to manually register Tabular Editor 3 with Power BI Desktop if using the portable version.
Bugfixes in 3.0.6:
- Can now use the
EvaluateDax,ExecuteCommand,SelectTable,SelectMeasureetc. methods in C# scripts (similar to Tabular Editor 2.x), see #44. - The
CustomActionC# script method now works properly, see #79. - Better reestablishing of connections to AS (should see fewer "connection lost" crashes)
- Best Practice Analyzer can now be instantiated through a C# script:
new TabularEditor.Shared.BPA.Analyzer();- this is different than in Tabular Editor 2.x in which the Analyzer class resided in a different namespace. See issue #45 - Copy operations are now supported when folders are selected, see #84
- Improved filtering of date columns in the Table Preview, see #77
- Fixed a bug where semantic engine feature overrides were not in effect, see #62.
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
Improvements in 3.0.5:
- Diagram view now looks much better (in both light and dark themes), and relationship routes are updated while tables are dragged around on the canvas.
Bugfixes in 3.0.5:
- Expression Editor, if hidden, doesn't automatically pop up when selecting a diagram item / TOM explorer item. Instead, double-click on the item in the TOM Explorer or bring it back using the View menu (see issue #43.
- DAX parser should no longer report circular dependencies when there are none (see issue #63 and #64)
- Fixed an issue with DAX parser determination of SourceColumn values on CalculatedTableColumns, which could cause columns to be deleted (and by extension, relationships) upon model load.
- DAX parser now shows an error if certain keywords are used as DAX variables (which is not allowed). See issue #58.
- Hitting ':' when starting a search, now immediately switches to "Entire Model" and Dynamic LINQ mode.
- Dynamic LINQ now also search partitions and calculation group items, see issue #70.
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.