Data Modelling — Data Goblins Blog

All tagged Data Modelling

Aug 1

Aug 1 Format Power Query in Power BI (Updated)

This short post explains how to format Power Query automatically in Tabular Editor using a C# Script to call the powerqueryformatter API.

Jul 28

Jul 28 Basic Line Charts in Power BI

Kurt Buhler

Data Visualization

In this article, I share the different variants of line charts you can create with Power BI, and provide free templates to try them yourself. I also discuss the impact of chart type selection and formatting in Power BI visuals, in the context of line charts.

Jul 26

Jul 26 Bar Charts in Power BI

Kurt Buhler

Data Culture & Adoption, Data Visualization

In this article, I share the different variants of bar charts you can create with Power BI, and provide free templates to try them yourself. I also discuss the impact of “Macguyvering” Power BI visuals too far.

May 24

May 24 Overview of new Microsoft Fabric Power BI Announcements

Kurt Buhler

Data Modelling, Administration, Data Culture & Adoption, Data Visualization, Getting/Transforming Data, Governance/Administration

In this short article, I share a visual overview of the MS Build announcements for Microsoft Fabric that are relevant for Power BI. Hopefully this makes it less overwhelming.

Apr 25

Apr 25 How to unlock new features in Power BI datasets managed with Tabular Editor

Kurt Buhler

Data Modelling

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.

Mar 7

Mar 7 Learn Tabular Editor with a Quiz (using a C# Script / Macro!)

Kurt Buhler

Data Modelling, Data Culture & Adoption

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!

Mar 3

Mar 3 Snek! The First Video Game for Tabular Editor 3.

Kurt Buhler

Feb 14 Check & Query Data from Tabular Editor

Kurt Buhler

Data Modelling

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.

Feb 7

Feb 7 Smart Buttons & Power BI Reporting

Kurt Buhler

Jan 5 Run Tabular Editor Macros with Keyboard Shortcuts & Toolbar Buttons

Kurt Buhler

Data Modelling

We look at how Tabular Editor shortcuts can revolutionize your productivity, linking them to macros, common actions and more.

Jan 5

Jan 5 Count Measures in Power BI Datasets with Tabular Editor

Kurt Buhler

Data Modelling

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.

Sep 1

Sep 1 Power BI Dataset Checklist

Kurt Buhler

Data Modelling

In this post, we look at what we can do to make our datasets easier to use, understand & maintain.

Aug 30

Aug 30 Designing Models and Reports for your Future Self: Part 1

Kurt Buhler

Data Culture & Adoption

In this post, we look at what can be done to facilitate a smoother handover of Power BI datasets & reports. First, we examine the mentality & activities needed to create sustainable, hygienic solutions, and why that is important.

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 22

Feb 22 The Goblin Behind the Model

Kurt Buhler

Data Culture & Adoption

In this article, we examine the importance of empathy in growing a data culture — one where others want to participate.

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.

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.