PowerBI.tips

Tabular Editor Rocks!

April 2, 2020 By Mike Carlo
Tabular Editor Rocks!

Tabular Editor is an incredible Tool that enables users to manipulate a Tabular model at lighting speeds.  Daniel Otykier is the creator of the Tabular Editor program. We are producing a video series to enable users of Power BI and data modelers for Analysis Services to learn more about this program.

Trust me this will be the best 4 hours of learning you will do this year. Learn about Tabular Editor and how it can save you HOURS of time. It will be worth it.

In this Series

This series will be broken down in to four topics.

  • Introduction
  • Using Scripting to remove repetitive tasks
  • Best Practice Analyzer to ensure your model is top notch
  • Incorporating DevOps with Tabular Models

Introduction

Daniel walks us through the basics of the program. We get a little bit of history on how the tool was developed and why you need to know about it.

Using Scripting

This by far is where the tool shines. Scripting allows users to automate common tasks for, creating measures, adding descriptions, building common calculations, hiding measure and more.

Best Practice Analyzer

Model running slow? This feature of Tabular Editor will allow you to quickly review your entire model and find areas for improvement.

DevOps

Once you have a data model how do you control versions? Or, can multiple people work on the same data model? Yes, to both of these questions. This video discusses manage data models with a DevOps pipeline.

All Videos

What all the videos in the series from Start to finish.

More about Daniel

Slides for Tutorials

[Click this link to download](https://pbitipsblob.blob.core.windows.net/externalshare/Tabular Editor Part 1 - Part 4.zip) all the power point slides for this tutorial series.

Previous

Milwaukee Brew City PUG – Feb 2020

More Posts

Sep 24, 2026

Agentic Dev of PBI Reports – Ep.566

Kurt Buhler tells Tommy Puglia and Mike Carlo that a full Power BI report from an agent went from a bad idea to a half-hour build in the span of a week. The catch, in his telling, is the report format, the context you bring, and a requirements process that now has to scale past a single page.

Sep 22, 2026

Your Identity and Power BI – Ep.565

Tommy Puglia, Mike Carlo, and Kurt Buhler spend this episode on what is left of the Power BI identity once Microsoft Fabric and agents are part of the job. The skill that still decides the work is judgment: listening to the business, and staying critical of what an agent hands back.

Sep 17, 2026

Self Aware in Data and AI Literacy – Ep.564

Power Query is moving a set of cloud connectors from ODBC to ADBC, and legacy Power BI Q&A now stays through February 2027. Kurt Buhler joins Tommy Puglia and Mike Carlo to sort out what data literacy and AI literacy require once Microsoft Fabric and agents make it easy to build faster than a team can review.