This short post explains how to format Power Query automatically in Tabular Editor using a C# Script to call the powerqueryformatter API.
All tagged Tabular Model
This short post explains how to format Power Query automatically in Tabular Editor using a C# Script to call the powerqueryformatter API.
This ‘article’ is a short quiz you can use to practice DAX in your browser on the website dax.do.
In this short article, I show you how to upgrade the compatibility level of models managed in Tabular Editor to be able to use new/preview features like Dynamic Format Strings.
In this article, I share a C# script to run a randomized, 10-question, eduacational quiz about Tabular Editor.
Learn Tabular Editor… inside of Tabular Editor!
This article is a fun one-off sharing a Tabular Editor C# script to play a Snake game.
In this article we look at four different ways to query data from within Tabular Editor. I also share a C# script to query or test selected columns and/or measures.
We look at how Tabular Editor shortcuts can revolutionize your productivity, linking them to macros, common actions and more.
This short article explains how to quickly count measures (or any model object) in Tabular Editor. A C# script is provided to count all model objects as a quick pop-up.
In this article, we compare different methods to let users to dynamically select measures in reports & pivot tables.
In this post, we look at what we can do to make our datasets easier to use, understand & maintain.
Scripts for TE2 and TE3 to automate querying of DMVs to document your model.
This article we examine what are Dynamic Management Views (DMVs) and how to query them from Tabular Editor 3. In the next article, we leverage the DMVs to automate documentation and tasks in our model.
In this article, we look at why using the VertiPaq Analyzer - integrated in Tabular Editor 3 & DAX Studio - should be your first step when analyzing a dataset. Describe your models and find easy optimization steps with this handy tool.
Let’s set up some basic Source Control in Power BI, with Tabular Editor, Azure DevOps/Git & Visual Studio!
In this post, I give a brief step-by-step tutorial on setting up basic Source Control in Power BI, and explain how Tabular Editor helps your source control in Power BI, by leveraging the TE folder structure save format.
It’s no big secret that source control is challenging in Power BI.
There are few native tools which enable source control in Power BI, allowing you to track changes and work collaboratively with colleagues on a Power BI dataset. Thankfully, however, external tools make this quite easy, for example, leveraging the folder structure save format of Tabular Editor.
This post is a simple introduction to source control as it pertains to a Power BI dataset, and how to set it up.
If you want to learn Tabular Editor, this is a good place to get started. This is a walk-through of some basic settings and uses of the tool, including how to find your way around and customize the user interface, and create, modify and organize objects in the model.
Tabular Editor is a must-have tool for making better data models faster in Power BI. However, there are 4 licenses, which have their own costs or limitations. I frequently get questions from colleagues and clients about which they need, or what the difference is.
To make this easier I’ve built an interactive Power BI guide to the Tabular Editor licenses.
Tabular Editor (TE) is a powerful, high-quality, external tool for Power BI & AS Tabular Models that helps you make better models more effectively. Since adopting TE in my Power BI workflow, time on dev tasks has been reduced ~60% compared to when I used Power BI alone. What is this tool, exactly, and how can it help us develop better Power BI data models?
In this article we look at how to format all DAX in Power BI datasets at once. With the push of a button your DAX will be formatted using these C# scripts! Save them as macros and never waste time formatting again.