Data Goblins Blog — DATA GOBLINS

All in Data Modelling

Mar 15

Mar 15 Assess an Existing Dataset with Tabular Editor 3 - Part 3: Extend DMVs with C# Scripts & Macros

Kurt Buhler

Data Modelling

Scripts for TE2 and TE3 to automate querying of DMVs to document your model.

Mar 8

Mar 8 Assess an Existing Dataset with Tabular Editor 3 - Step 2: Query DMVs

Kurt Buhler

Data Modelling

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.

Mar 1

Mar 1 Analyze a Dataset with Tabular Editor 3 - VertiPaq Analyzer

Kurt Buhler

Data Modelling

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.

Feb 8

Feb 8 View & Edit Power Query in Tabular Editor

Kurt Buhler

Data Modelling

Tabular Editor is not only a helpful tool for developing DAX. You can also use it to view & modify your Power Query M code, without ever opening Power BI desktop. Furthermore, there also exists a formatter for Power Query that can help you make your code easier to read & manage. Here, I walk through the basics, the use-cases, and a small tutorial on how to do this, yourself.

Feb 1

Feb 1 Track Changes in Power BI: Part 3 - Workspace Mode

Kurt Buhler

Data Modelling, Governance/Administration

Using Tabular Editor 3 & Workspace mode, source control is that much easier, even when using Branching!
In this article, I explain how workspace mode in Tabular Editor 3 makes Source Control easy by letting you simultaneously save changes to disk but also to a service dataset for testing. I then explain how this can work when collaborating on a model, for example, using Git Branching in Power BI development.

Feb 1

Feb 1 Track Changes in Power BI: Part 2 - Tutorial

Kurt Buhler

Data Modelling, Governance/Administration

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.

Feb 1

Feb 1 Track Changes in Power BI: Part 1 - Introduction

Kurt Buhler

Data Modelling, Governance/Administration

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.

Jan 25

Jan 25 A Beginner's Guide to Tabular Editor 3: UI Customization & Code Assist Features

Kurt Buhler

Data Modelling

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.

Jan 11

Jan 11 Tabular Editor - Which License is Right for You? An Interactive Guide.

Kurt Buhler

Data Modelling

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.

Jan 4

Jan 4 Tabular Editor – Supercharge your Power BI Development

Kurt Buhler

Data Modelling

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?

Dec 28

Dec 28 Format all DAX in your model at once with Tabular Editor

Kurt Buhler

Data Modelling

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.

Sep 15

Sep 15 Selectable dimensions in Power BI

Kurt Buhler

Data Modelling, Data Visualization

In this article we look at how to have dynamic dimensions in Power BI so that users can choose fields that appear on visual axes, table rows or other categorical elements.