Data Modelling — Data Goblins Blog

Data Prep, Data Modelling, Data Culture & Adoption, Governance, Data Visualization

In this article, I discuss why quality is a often problem for data and analytics, and how DataOps can help.

Oct 18

Oct 18 Case-sensitive models in Power BI: consequences & considerations

In this short article, we look at the consequences of having a case-specific collation in your Power BI semantic model. This is particularly important as Direct Lake models created in the Fabric user experience have a case-sensitive collation applied, automatically.

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.

May 28

May 28 DAX.do quiz

May 24 Overview of new Microsoft Fabric Power BI Announcements

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

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.

Apr 4

Apr 4 How to manage “Reporting Objects” in a Power BI Dataset

Data Modelling, Data Visualization, Getting/Transforming Data

In this article, we tackle the growing issue of ‘report-specific objects’, dataset measures and tables created to fill specific report visual requirements, why they negatively impact self-service users, and best practices to mitigate this impact.

Mar 7

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

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!

Feb 28

Feb 28 “It Depends” - Power BI Best Practices & Optimizations

Data Modelling, Data Visualization, Getting/Transforming Data

In this article, we look at the difference between best practices and optimizations. We also define a four-step method to tackle complex issues with dataset/report performance and design.

Feb 14

Feb 14 Check & Query Data from Tabular Editor

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.

Jan 5

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

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

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.

Dec 27

Dec 27 Learn Power BI with Sample Datasets: Part 2 - Personal Data Projects

In this post, we examine how personal data can be used in personal projects to help us learn Power BI.

Dec 20

Dec 20 Learn Power BI with Sample Datasets: Part 1 - Contoso Data Generator

In this post, we look at how to create our own SQL Database and fill it with data from the Contoso Data Generator, so we can get some hands-on Power BI experience.

Nov 8

Nov 8 Measure Selection in Power BI

In this article, we compare different methods to let users to dynamically select measures in reports & pivot tables.

Oct 18

Oct 18 Converting a Power BI Dataset .bim to a .pbix with pbi-tools

Have you ever wondered how to convert Power BI metadata (i.e. from Tabular Editor) to a .pbix? Recently, I needed to do this. Thankfully, pbi-tools (and Mathias Thierbach) came to the rescue! This is not supported by Microsoft, but it’s interesting to know that this approach does exist.

Sep 1

Sep 1 Power BI Dataset Checklist

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

Jun 28

Jun 28 Visualize Power BI Dependencies with Tabular Editor and Mermaid