Tabular Editor 3.1.0
- Download Tabular Editor 3.1.0 (64 bit) (recommended)
- Download Tabular Editor 3.1.0
- 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.
New features in 3.1.0
- The Table Import Wizard is finally here! And it's better than ever before. Read this article for more information. It currently works for SQL, ODBC and OLE DB, but let us know if you need support for other types of data sources.
- Offline (i.e. without being connected to Analysis Services) detection of table schema changes now works - even for M partitions and implicit data sources.
- Objects can now be shown/hidden in perspectives through the TOM context menu, similar to TE2.
- The Import/Export translations option is now available, similar to TE2.
- Added the Batch Rename Dialog, similar to TE2 (the dialog shows up when selecting multiple objects and hitting "F2" for rename).
- Added the Mark as Date Table dialog, similar to TE2.
Improvements in 3.1.0
- Copying a single cell from a DAX query result now formats the value such that it can be easily pasted into a DAX expression, see #200.
- Added "Delete relationship" option to diagram context menu, see #195.
- Added "Remove field" option to Pivot Grid context menu.
- Model-wide actions such as Create Table, Refresh, Import Tables, etc. are now available through the "Model" menu.
- AuthenticationKind property on Structured Data Sources now has a dropdown. The Options property can now be edited as well and the Query property has been exposed.
- TOM Explorer context menu items have been rearranged to align better with TE2.
- Role members can now be edited directly by right-clicking on a role.
- Dependencies can now be copied from the Dependency View to either Text/JSON format, similar to TE2.
- New skin palette options for the "Basic" and "Bezier" skins (which are vector based, and thus look much better in Hi-DPI than the VS-like skins). Find the new palettes at the bottom of the "Window" menu.
Bugfixes in 3.1.0
- Fixed an issue with the Select Database dialog when sorting the databases, see #201.
- Fixed a crash with the Select Display Folder dialog, see #199.
- Fixed a crash when switching from the Classic workspace, see #198.
- Translations and perspective info is now retained when dragging/dropping calculated columns or measures between tables, see #194.
- Fixed an issue with unwanted newlines in M code, see #193.
- Fixed a focus issue with the Add Table to Diagram dialog, see #183.
- Fixed a crash when right-clicking various places in a Pivot Grid, see #175.
- Fixed an issue with unwanted TOM refreshes from interfering external change traces.
- Fixed an issue with Workspace Mode warning about Unsaved Changes
- Remove memberId property when deploying roles, see TE2 #906.
- Fixed issue with TOM Explorer copy/paste ops (possible related to #184).
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
- *Schedule data refreshes
- Update Table Schemas on both Provider and Structured Data Sources (yes, even for M queries!)
- 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