- Download Tabular Editor 3.0.9 (64 bit) (recommended)
- Download Tabular Editor 3.0.9
- 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.
Bugfixes in 3.0.9
- Included a missing DLL which would otherwise cause a crash when trying to add role members
Improvements in 3.0.8
- Added option for executing only selected EVALUATE statements in DAX queries (shortcut Shift+F5), see issue #47.
- Allow using shortcut Ctrl+/ to comment/uncomment code, see issue #46. You can also change the comment style (-- or //) under Tools > Preferences > DAX Editor > General.
- DAX Script will now also script measure KPIs, calculated columns and calculated tables in the current selection. We also add comments to make the code more readable (this can be disabled under Tools > Preferences > DAX Scripting).
- There is now an option to automatically add a line break character at the beginning of all DAX expressions, when working against a Power BI model. This makes the code look better in the Power BI Desktop formula bar. This can be disabled under Tools > Preferences >, see issue #26.
- When adding Windows AD Role Members, the Directory Object Picker dialog now appears, see issue #152.
- The "Add Deployment Metadata" option is now available under Tools > Preferences > Model Deployment.
- Pivot Grid improvements:
- You can now drag TOM Explorer objects into all areas of the Pivot Grid, see #49.
- Added TOM Explorer context menu option for adding measures, columns and hierarchies directly to a Pivot Grid.
- Added "Show field" button in Pivot Grid, to display all available fields on the connected database.
- Added a "Go to object" right-click menu option in the Pivot Grid.
- Relationship errors (ambiguous paths, invalid state, etc.) are now detected and indicated in the TOM Explorer
Bugfixes in 3.0.8
- Changed color of the "Execute query" exclamation mark from red to green.
- Fixed a crash when reversing relationships through the Diagram View
- Fixed an issue with the Relationship Editor where changes are not correctly saved
- Fixed a crash which would occur when TE3 is launched from PBI Desktop while an instance of SSAS is running on the local machine.
- Fixed a bug that prevented creation of new models with a workspace database on Power BI XMLA endpoint.
- Fixed a bug where code selection was cleared after using the Comment action.
- Deployment Wizard now remembers the last server used.
- DAX Script calculated column expressions should no longer give false semantic error messages about missing row context.
- Fixed a bug preventing Business Edition license holders to use the Visual Studio Integrated Workspace server.
- Fixed "successful" typo.
- Fixed an issue with auto formatter sometimes duplicating code when entering a right-parenthesis.
- Added "Save Model.bim backup" option in UI, see issue #37.
- Perspective selection should no longer get "stuck", see issue #52.
- Property grid now properly displays date formatting examples, see issue #86.
- Fixed highlight color when searching, see issue #98.
- "Find All" now works as expected, see issue #107.
- Calculation Item that causes measure data types to decay to Variant is now correctly picked up, see issue #111.
- Fixed false semantic error when using EARLIER in a filter, see issue #118.
- Fixed false semantic error when using KEEPFILTERS, see issue #122.
- Blank (or comment only) Detail Rows Expression no longer causes an error indication, see issue #127.
- Fixed multiple credential prompts, see issue #131.
- Fix vpax import issue, see issue #133.
- Fixed property grid behavior when selecting a display folder, see issue #134.
- Diagram no longer deletes table when hitting "Delete" (remove from diagram instead), see issue #139 .
- Pivot Grid should now handle date fields correctly, see issue #142.
- Copying a calculation group will no longer create measures with duplicated names, and the precedence number will also be changed to ensure uniqueness, see issue #155 and #156.
- Uncomment Code button now works for lines that have indentation, see #159.
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.7
- Allow using a custom compiler for C# scripts, see issue #97
- Auto date/time column warnings can now be hidden (under Tools > Preferences > Tabular Editor > Hide auto/date time warnings). See issue #99
Bugfixes in 3.0.7
- "Standard Edition" has been renamed to "Business Edition"
- Fixed an issue with the semantic analyzer which would sometimes cause stack overflow exceptions and crash the tool (see issue #95).
- Fixed an issue with the semantic analyzer which would sometimes report non-existing circular dependency errors.
- Semantic analyzer now supports the SUBSTITUTEWITHINDEX DAX function
- Fixed an issue with some of the JOIN DAX functions (NATURALINNERJOIN, etc.) which would sometimes return the wrong set of columns (see issue #103)
- Autocomplete now only shows relevant columns/tables in RELATED and RELATEDTABLE (see issue #112)
- Autocomplete now works with ORDER BY (see issue #53)
- Editor now longer disappears when creating a folder, copy/pasting a single object, etc. (see issue #90)
- All relevant context menu items should now show for calculation groups (including refresh options), see issue #100
- Fixed an issue with DAX queries now returning any results when an ORDER BY statement was added to the query, see issue #108
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.
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.