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
- Follow Daniel on Twitter
- Connect with him on LinkedIn
- Download Tabular Editor
- Learn More about Tabular Editor on the Wiki
- Submit your idea for Tabular Editor
Slides for Tutorials
Click this link to download all the power point slides for this tutorial series.
If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials. Subscribe to our YouTube Channel. Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.
Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:
Check out the new Merch!
Hey Daniel,
I just recently found the tabular editor and am loving it. What a wonderful product! I’m so thankful that you shared this awesome tool with the community. Thank you, thank you, thank you!
In part four of the tutorial I became super excited with the DevOps build/deployment to AAS. I would love to get the yaml for each step, or more details on each step! I’m not sure if you can export a build? I’m having difficulties reproducing this at my company and any additional details would help a ton.
Last question is will the pausing and unpausing of AAS also work for Power BI Embedded?
Thanks again!
Check out Daniel’s series on Dev Ops
https://tabulareditor.com/2019/02/20/DevOps1.html
https://tabulareditor.com/2019/06/28/DevOps2.html
https://tabulareditor.com/2019/10/08/DevOps3.html
https://tabulareditor.com/2019/10/17/DevOps4.html
https://tabulareditor.com/2020/06/20/DevOps5.html
for the implementation steps.
Pausing AAS will work for Power BI Embedded. However while AAS is paused your Power BI model will not render. You will likely get some sort of rendering error about datasets not found or connection broken.