Take off with Tabular Editor
summary
Attaches to Power BI Desktop and runs free as Tabular Editor 2, letting the model be edited externally: creates measures (example: CountRows and Distance sum), builds folders, batch-formats many measures, and pushes changes back to the report. Uses C# scripting macros stored on the C: drive to generate “Rows in <table>” and multiple time-intelligence measures automatically. Shows dependency graphs, a column search/filter to find all date fields, runs DAX Evaluate to preview rows, and runs Best Practice Analyzer to auto-fix issues (reduced flags to 127).
AI-written summary · about
chapters (10)
- 0:00Tabular Editor intro
- 1:11What is Tabular Editor
- 2:38Setup with Power BI Desktop
- 4:22Measures in Tabular Editor
- 6:52C# scripting for measures
- 9:40Time intelligence & dependencies
- 13:36Filtering & date formatting
- 16:07DAX validation with C#
- 17:10Best Practice Analyzer
- 18:58Summary & Q&A
related talks
43mBecome a Power BI Data Modeling Wizard using Tabular Editor 3
48mCombine Power BI with External Tools
01h 08mAdvanced Modelling and Calculation Using the Power BI Designer
51mTroubleshooting Power BI Report Performance
47mPower BI Meets Programmability – TOM, XMLA, and C#
50mTroubleshooting Power BI Reports
50mThe Path to Success with Power BI: Best Practices
47mFrom Power BI to Excel - The best of two worlds