TabularEditor/TabularEditor 2.27.1

Tabular Editor 2.27.1

on GitHub

• Windows installer: TabularEditor.2.27.1.Installer.msi
  • SHA256: 54307E8A1F1C81259FCE5CB0C63523B49F043F5147B90C676CF2D972762DD50C
• Portable version: TabularEditor.2.27.1.zip
  • SHA256: 05141FC996392EC9E4087927F5B5A58D898B8A92117D9A8CF4AA81CEFB5DD7C1

Bugfixes and improvements in 2.27.1

• The MSAL.NET client library was updated to 4.72.1, which is the latest library that's not deprecated but also known to "play nicely" with the AS client library for connecting to the XMLA endpoints of Power BI / Azure Analysis Services.
• Fixed a bug where the "msalruntime" DLLs were not properly included in the .zip / .msi versions of Tabular Editor 2. In newer versions of the MSAL.NET client library, these DLLs are required. Before this fix, users who did not have the DLLs preregistered in their machines GAC would face issues while attempting to connect, as discussed in #1269, #1290, #1297. The inclusion of these DLLs in the .zip / .msi files for Tabular Editor explains why the size of these files have also gone up substantially.
• A "Fix Expression Editor" tab has been added to the Edit Best Practice Rule dialog, so you no longer need to edit the BpaRules.json file to a specify a FixExpression. Thanks to @mlonsk for this contribution!

New in 2.27.0

• Tabular Editor now supports DAX UDFs, including the following features:
  • Batch rename
  • Automatic formula fixup both for function names, and for object references inside the function body
  • Functions appear in the Show dependencies dialog
• Tabular Editor now also supports Calendars, including the following features:
  • Automatic formula fixup for calendar names
  • Calendars appear in the Show dependencies dialog
• There is a new Import TMDL... option in the Model menu, which is useful when you want to bring in objects from a TMDL script, such as packages of UDFs from https://daxlib.org.

Improvements in 2.27.0

• Updated AMO/TOM to 19.104.1
• Added a new authentication option, "Microsoft Entra MFA", which will force the account selector pop-up. This is useful in case you want to use a different account to connect to Power BI / Azure Analysis Services, than the one connected as your Work & School Account in Windows.
• The Schema Name property is now shown and can be edited on EntityPartition objects. Thanks @rubenhillstar
• Support for BindingInfo, QueryGroups and better validation when copying/pasting objects, in order to avoid subsequent "invalid object reference" errors, when subsequently saving the changes to Analysis Services.
• Added a new UI and CLI deployment option, -S / -SHARED, to indicate that Shared Expressions should be deployed. Omitting this switch during a deployment (-D / -DEPLOY) operation will cause the Shared Expressions to be left as is. See also #1258.
• As the number of CLI switches you had to add to perform a full overwrite deployment has become a bit unwieldy, we've added a new -F / -FULL switch. In other words, the following commands are now equivalent:

tabulareditor.exe "c:\path\to\database.tmdl" -D "localhost" "model" -O -C -P -S -R -M
tabulareditor.exe "c:\path\to\database.tmdl" -D "localhost" "model" -F

Bugfixes in 2.27.0

• Fixed a bug where you could not make any changes to a model in Power BI Desktop September 2025, unless enabling Allow unsupported Power BI features, which is not necessary as Power BI Desktop now supports any modeling change from 3rd party tools, see #1293.
• When adding a new partition to a table, it should now receive proper focus in the TOM Explorer

Other news

The TOMWrapper library including the namespaces and classes needed to run the Best Practice Analyzer is now available as a standalone solution/project which targets both .NET Framework and .NET 6 / .NET 8. Huge thanks to @mthierba for his contributions to this! If there is a demand, we will look into packaging this library on NuGet.