# Data Goblins > I help you make useful things with data and AI. Written by Kurt Buhler. Every page has a markdown version: add .md to its URL. ## Pages - [Writing](https://data-goblins.com/index.md): Every published article by topic - [Portfolio](https://data-goblins.com/portfolio.md): Sites, data apps, Power BI reports and tools - [About](https://data-goblins.com/about.md): Who writes this site - [Archive](https://data-goblins.com/archive.md): Older articles - [Privacy policy](https://data-goblins.com/privacy-policy.md): How personal data is handled - [Cookie policy](https://data-goblins.com/cookie-policy.md): What is stored in the browser # Articles ## Semantic models - [Case-sensitive models in Power BI: consequences & considerations](https://data-goblins.com/case-specific.md): 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. - [DAX.do quiz](https://data-goblins.com/dax-do-002.md): This ‘article’ is a short quiz you can use to practice DAX in your browser on the website dax.do. (archived, may be out of date) - [How to manage “Reporting Objects” in a Power BI Dataset](https://data-goblins.com/reporting-layer.md): 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. - [“It Depends” - Power BI Best Practices & Optimizations](https://data-goblins.com/it-depends.md): 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. - [Learn Power BI with Sample Datasets: Part 2 - Personal Data Projects](https://data-goblins.com/personal-data.md): We examine how personal data can be used in personal projects to help us learn Power BI. - [Power BI Dataset Checklist](https://data-goblins.com/dataset-checklist.md): We look at what we can do to make our datasets easier to use, understand & maintain. - [Adding tables in Power Query using Tabular Editor](https://data-goblins.com/modify-static-tables-in-tabular-editor.md): A quick tutorial about how to add or modify static data tables (i.e. those created with Enter Data) using Tabular Editor 2 or 3. (archived, may be out of date) - [Analyze a Dataset with Tabular Editor 3 - VertiPaq Analyzer](https://data-goblins.com/analyze-power-bi-dataset.md): 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. ## Reports and visuals - [Fix Power BI “Something is wrong with one or more fields”](https://data-goblins.com/something-is-wrong-with-one-or-more-fields.md): We look at a 5-step process to replace fields in a report when you’ve re-named, moved, or deleted them in the model. You can also use this method to “hot swap” different fields in and out of a visual without losing formatting. This isn’t officially supported, but it’s easy and it’s a huge time-saver. - [KPIs and cards in Power BI](https://data-goblins.com/kpi-templates.md): In this collaboration with Štěpán Rešl, I share some tips and templates to design effective KPI visuals. - [How to set table or matrix column widths in a Power BI report](https://data-goblins.com/set-column-widths.md): I share a quick and easy way to manually set table and matrix column widths in Power BI by using the new Power BI Projects (.pbip) file format. This is an unsupported feature, but it works reliably. (archived, may be out of date) - [Basic Line Charts in Power BI](https://data-goblins.com/line-chart-basics.md): 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. (archived, may be out of date) - [Bar Charts in Power BI](https://data-goblins.com/bar-charts.md): 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. (archived, may be out of date) - [Measure Selection in Power BI](https://data-goblins.com/measure-selection.md): We compare different methods to let users to dynamically select measures in reports & pivot tables. (archived, may be out of date) - [Power BI Data Visualization - Ideas & Wishlist](https://data-goblins.com/visual-wishlist.md): Power BI is a powerful tool that has also enabled millions of people worldwide to easily visualize & explore their data. Despite that, inflexibility to the visualization configuration and formatting can make it difficult to fulfill visual requirements. What are some of the biggest feature gaps with data visualization in Power BI, and why is this important? (archived, may be out of date) - [Power BI Report Checklist](https://data-goblins.com/report-checklist.md): I list some tips for checking to make sure your report is ready for handover to someone else. - [Disable Auto-scaling in Power BI Visuals](https://data-goblins.com/disable-font-autoscaling.md): ‘Responsive Visuals’ is a lesser-known feature that in general helps users make better graphs without fawning over visual settings & parameters. However, disabling it might be necessary at times when you are trying to achieve a specific result that Power BI default visuals won’t seem to permit. (archived, may be out of date) - [Fix Visuals or Replace Measures in Power BI Reports using pbi-tools](https://data-goblins.com/replace-report-measures.md): It’s frustrating that in Power BI re-naming measures or moving them to another table will break any visuals using them in reports. Likewise, Power BI does not have a feature to hot-swap measures in visuals, to retain formatting or save time. Here I will show you an easy way to replace multiple measures in a Power BI report, including those used in “broken” visuals. Fix all broken visuals in Power BI reports using this method! (archived, may be out of date) - [How to Analyze YouTube & YouTube Music History with Power BI (or Excel)](https://data-goblins.com/youtube-data-in-power-bi.md): Ever wondered how to get your YouTube music history? Or how to get your YouTube watch or search history?Here I explain how to do that with a step-by-step tutorial and some sample files to help you analyze your YouTube history, yourself. There’s a lot of fun questions you can answer, like what you listen to most, or how that has changed over time. (archived, may be out of date) - [How to hide blanks in Cards & KPI visuals in Power BI, easily](https://data-goblins.com/hide-blanks-in-cards-and-kpi-visuals.md): The default Cards & KPI visuals are frequently the first visual a report user will see. It is thus important that they contain meaningful values. Unfortunately, for many users, a (Blank) is not meaningful, either because it is not understood, or they expect to see 0, instead. Here I explain how you can easily hide these blanks with conditional formatting, or a few methods to replace the (Blank) with 0. (archived, may be out of date) - [Visualizing Microsoft Planner & Tasks data in Power BI](https://data-goblins.com/planner-to-powerbi.md): We look at how to get Microsoft Tasks / Planner data into Power BI, to make analytical reports from our operational Planner boards. (archived, may be out of date) - [How to make effective slope charts in Power BI](https://data-goblins.com/slope-chart.md): How to build a slope chart from a small Power BI line chart to show growth between two periods, for one metric or several categories at once. (archived, may be out of date) - [How to make a Waffle chart without custom visuals in Power BI](https://data-goblins.com/waffle.md): We look at a method for creating waffle charts in Power BI with the default visuals. (archived, may be out of date) - [How to label the latest data point in a Power BI line or area chart](https://data-goblins.com/label-latest-datapoint.md): We look at a method to format a single data point in a Power BI visual. Specifically, we look how to label the latest data point in a line chart. This method also works with individual formatting of other data points. (archived, may be out of date) - [Selectable dimensions in Power BI](https://data-goblins.com/selectable-dimensions.md): 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. (archived, may be out of date) - [What are 'Details-on-Demand' matrixes in Power BI?](https://data-goblins.com/details-on-demand-matrix.md): We examine a method to create dynamic hierarchies in Power BI. This is particularly useful for creating ‘details-on-demand’ matrixes; interactive pivot tables in Power BI. (archived, may be out of date) - [KPI Tab page navigation in Power BI](https://data-goblins.com/kpi-tab-navigation.md): We look at a way of creating a folder-tab navigation experience using the KPI and Card visuals. Users click on the KPI or Card and then get more details for that metric. (archived, may be out of date) ## Admin and governance - [Power BI Deployment Pipeline Checklist](https://data-goblins.com/deployment-pipeline-checklist.md): Application lifecycle management & staging in Power BI; deploy content, view deployment history & set up a mature Power BI ecosystem. (archived, may be out of date) - [Power BI Workspace Checklist](https://data-goblins.com/workspace-checklist.md): Publish content to cloud workspaces on the service for collaboration and distribution. Workspace set-up is one of the most important aspects of governing & planning your Power BI implementation. (archived, may be out of date) - [Power BI Data Gateway Checklist](https://data-goblins.com/gateway-checklist.md): Securely shuttling data to cloud tools & systems from on-premises sources, or traversing private networks. (archived, may be out of date) - [Power BI Analyze-in-Excel Checklist](https://data-goblins.com/excel-checklist.md): We examine considerations for implementing & governing Analyze-in-Excel in your Power BI self-service ecosystem. (archived, may be out of date) - [Power BI App Checklist](https://data-goblins.com/app-checklist.md): We look at how to make a good Power BI app. Paying attention to these checklist items will result in more professional, consistent app experiences that make it easier for users to find what they need and for you to drive adoption of reports. - [Power BI Dashboard Checklist](https://data-goblins.com/dashboard-checklist.md): We look at what we need to make a good dashboard, and some important considerations with access & permissions (archived, may be out of date) - [Exploring App Audiences in Power BI](https://data-goblins.com/app-audiences.md): We explore Power BI App Audiences and why they are such a powerful feature for managing and using content in Power BI Apps. (archived, may be out of date) - [Can't Enable Audit Log in Office Compliance Portal](https://data-goblins.com/sorry-we-couldnt-update-your-organization-settings-please-try-again.md): Having difficulties enabling the audit logs in the admin / compliance portal? Getting an error ‘Sorry! We couldn’t update your organization settings. Please try again.’? Turns out it’s because your tenant might be ‘dehydrated’. (archived, may be out of date) - [Monitoring Power BI using REST APIs from Python](https://data-goblins.com/power-bi-api-python.md): I explain how to call the Power BI REST APIs from Python. You can do this either with a dedicated user or a Service Principal registered from the Azure Portal. I’ll walk through the necessary steps to get this working. (archived, may be out of date) - [Get Power BI Dataset Refresh History using Python](https://data-goblins.com/get-power-bi-refresh-history-python.md): I explain how to get dataset refresh history from Power BI using Python. For this method, you need to be a tenant Admin, and it is limited to only 7 days or 60 refreshes, per dataset. For more history, you need another API or method. (archived, may be out of date) - [Get Publish-to-Web & Org. share links from Power BI API with Python](https://data-goblins.com/get-publish-to-web-power-bi-python.md): I explain how to call the Power BI APIs from Python with a Service Principal to get all the publish-to-web and cross-org share links in your tenant, which pose a big governance risk. (archived, may be out of date) - [Get Workspaces from Power BI API with Python](https://data-goblins.com/get-workspaces-power-bi-python.md): I explain how to call the Power BI APIs from Python with a Service Principal to get all the workspaces managed in your tenant. I share also a github gist for a Python script which retrieves all workspace objects, including users, datasets, reports, etc. (archived, may be out of date) - [Get Deployment Pipelines from Power BI API with Python](https://data-goblins.com/get-deployment-pipelines-power-bi-python.md): I explain how to call the Power BI APIs from Python with a Service Principal to get the deployment pipelines managed in your tenant. (archived, may be out of date) - [Extracting Power BI Tenant Settings with Power Automate Desktop](https://data-goblins.com/export-power-bi-tenant-settings.md): We look at a simple way to extract the tenant settings from Power BI using Power Automate Desktop and a UI Automation / RPA flow. Inside, we have a summary of the settings and recommendations for each, as of April 2022. (archived, may be out of date) - [Track Changes in Power BI: Part 5 - Using pbi-tools](https://data-goblins.com/version-control-pt5.md): We look at some tips to best use pbi-tools and how to automate pbi-tools execution in the background, using Power Automate Desktop flows. (archived, may be out of date) - [Track Changes in Power BI: Part 4 -Reports](https://data-goblins.com/version-control-pt4.md): pbi-tools is a command-line tool that enables Source / Version Control of Power BI (thin) reports and datasets. Much like the folder structure generated by Tabular Editor, pbi-tools creates a Report Layout structure based on files in the .pbix. In these articles, we go into the background of this tool & how to use it.An important note if you are using Sensitivity Labels - files with Sensitivity Labels are currently not supported with pbi-tools. More info on that at the bottom of the article. (archived, may be out of date) - [Track Changes in Power BI: Part 1 - Introduction](https://data-goblins.com/version-control.md): 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. (archived, may be out of date) - [Track Changes in Power BI: Part 2 - Tutorial](https://data-goblins.com/version-control-pt2.md): 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. (archived, may be out of date) - [Track Changes in Power BI: Part 3 - Workspace Mode](https://data-goblins.com/version-control-pt3.md): 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. (archived, may be out of date) - [How to create an Azure DevOps Repo using Git & Visual Studio](https://data-goblins.com/how-to-create-a-devops-repo.md): This article gives a beginner’s guide to creating a Repo in Azure DevOps. (archived, may be out of date) - [Automated Regression Monitoring in Power BI](https://data-goblins.com/monitor-data-quality.md): We examine a method to automatically monitor & test data quality in Power BI by setting up a composite model to detect data changes. (archived, may be out of date) ## Tools and automation - [Recover Power BI reports or models that you can’t download](https://data-goblins.com/cant-download-pbix.md): I explain several approaches to recover models and reports from a Power BI workspace when the Download this file (.pbix) option is greyed out. These methods involve use of either external tools or a Fabric notebook. - [Fix visuals, replace fields, and mass-format reports in Power BI](https://data-goblins.com/programmatically-modify-reports.md): I explain several use-cases for semantic-link-labs with reports, which involves programmatic modifications to report metadata to streamline certain report management tasks. This article explains how to do this with standard reports; future articles will elaborate about using the methods available for PBIR. - [Managing Power BI reports or models using semantic-link-labs](https://data-goblins.com/semantic-link-labs.md): I introduce semantic-link-labs, a library based upon semantic-link that you can use in Microsoft Fabric notebooks to help you build, use, manage, and audit not only semantic models, but also reports and other items or parts of Fabric. - [How to use Tableau with Power BI and Fabric](https://data-goblins.com/connect-tableau-to-power-bi.md): I’ll explain the how and why of:How to connect Tableau to Power BI semantic models.How to connect Tableau to Fabric lakehouses (and other items that have a SQL endpoint). - [Format Power Query in Power BI (Updated)](https://data-goblins.com/format-power-query-automatically.md): This short post explains how to format Power Query automatically in Tabular Editor using a C# Script to call the powerqueryformatter API. (archived, may be out of date) - [How to unlock new features in Power BI datasets managed with Tabular Editor](https://data-goblins.com/compatibility-level.md): 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. (archived, may be out of date) - [Learn Tabular Editor with a Quiz (using a C# Script / Macro!)](https://data-goblins.com/tabular-editor-quiz.md): I share a C# script to run a randomized, 10-question, eduacational quiz about Tabular Editor. Learn Tabular Editor… inside of Tabular Editor! (archived, may be out of date) - [Snek! The First Video Game for Tabular Editor 3.](https://data-goblins.com/snek.md): This article is a fun one-off sharing a Tabular Editor C# script to play a Snake game. (archived, may be out of date) - [Check & Query Data from Tabular Editor](https://data-goblins.com/tabular-editor-query-data.md): 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. (archived, may be out of date) - [Smart Buttons & Power BI Reporting](https://data-goblins.com/smart-buttons.md): We look at how to use Smart Buttons (flic) with Power Automate and Power BI to create and control types of event-driven reporting solutions. (archived, may be out of date) - [Count Measures in Power BI Datasets with Tabular Editor](https://data-goblins.com/count-measures-in-power-bi.md): 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. (archived, may be out of date) - [Run Tabular Editor Macros with Keyboard Shortcuts & Toolbar Buttons](https://data-goblins.com/tabular-editor-keyboard-shortcuts.md): We look at how Tabular Editor shortcuts can revolutionize your productivity, linking them to macros, common actions and more. (archived, may be out of date) - [Learn Power BI with Sample Datasets: Part 1 - Contoso Data Generator](https://data-goblins.com/sql-dataset.md): 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. - [Power BI Dataflow Checklist](https://data-goblins.com/dataflow-checklist.md): Dataflows can be a very useful and powerful data transformation tool to centralize & govern transformation logic. In this article are some points to consider when making & deploying Power BI Dataflows in your organization. (archived, may be out of date) - [Converting a Power BI Dataset .bim to a .pbix with pbi-tools](https://data-goblins.com/download-pbix.md): 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. (archived, may be out of date) - [Visualize Power BI Dependencies with Tabular Editor and Mermaid](https://data-goblins.com/visualize-measure-dependencies.md): I share a method in Tabular Editor to generate mermaid flowchart syntax to visualize model object dependencies. This code can be directly copied into an Azure DevOps wiki to automate documentation, or into mermaid.live to get an image of the resulting flowchart. (archived, may be out of date) - [The Impact Factor of Power BI External Tools](https://data-goblins.com/external-tools-impact-factor.md): I explain why External Tools are necessary & discuss the challenges in adopting them. - [Formatting Code for Blogs & Websites](https://data-goblins.com/formatting-code.md): This post is a running collection of tools that I use for formatting and highlighting code in my blog. The code that I share mainly pertains to Power BI, but includes also Python and C#. (archived, may be out of date) - [Running PowerShell from a Python GUI](https://data-goblins.com/powershell-in-python-gui.md): We look at how the report source control tool pbi-tools can be run in Python, and how to create a basic GUI in Python to support this. (archived, may be out of date) - [Assess an Existing Dataset with Tabular Editor 3 - Part 3: Extend DMVs with C# Scripts & Macros](https://data-goblins.com/te-dmv-scripts.md): Scripts for TE2 and TE3 to automate querying of DMVs to document your model. - [Assess an Existing Dataset with Tabular Editor 3 - Step 2: Query DMVs](https://data-goblins.com/dmvs.md): 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. - [View & Edit Power Query in Tabular Editor](https://data-goblins.com/edit-power-query-outside-power-bi.md): 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. (archived, may be out of date) - [A Beginner's Guide to Tabular Editor 3: UI Customization & Code Assist Features](https://data-goblins.com/learning-tabular-editor-part-1-beginner.md): 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. (archived, may be out of date) - [Tabular Editor - Which License is Right for You? An Interactive Guide.](https://data-goblins.com/tabular-editor-license-guide.md): 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. (archived, may be out of date) - [Tabular Editor – Supercharge your Power BI Development](https://data-goblins.com/what-is-tabular-editor.md): 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? (archived, may be out of date) - [Format all DAX in your model at once with Tabular Editor](https://data-goblins.com/format-all-dax.md): 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. (archived, may be out of date) ## Fabric - [What Microsoft Fabric means for your semantic models: New options and approaches](https://data-goblins.com/fabric-semantic-models.md): I explain what it means for your current and future semantic models if you choose for Fabric. This post isn’t meant to market Fabric to you; it’s purely informative. (archived, may be out of date) - [What Microsoft Fabric means for your semantic models: Scenario 1](https://data-goblins.com/fabric-semantic-models-scenario-1.md): I illustrate one example of how a team goes from using a semantic model in Power BI (Pro) to Fabric. (archived, may be out of date) - [What Microsoft Fabric means for your semantic models: Scenario 2](https://data-goblins.com/fabric-semantic-models-scenario-2.md): I illustrate an example of how a departmental analytics team goes from using a semantic model in Power BI to Fabric. (archived, may be out of date) - [What Microsoft Fabric means for your semantic models: Scenario 3](https://data-goblins.com/fabric-semantic-models-scenario-3.md): I illustrate an example of how an enterprise BI team takes their model from Power BI to Fabric. (archived, may be out of date) - [Overview of new Microsoft Fabric Power BI Announcements](https://data-goblins.com/fabric-announcements.md): 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. (archived, may be out of date) ## AI and coding agents - [Five Minutes to Wow](https://data-goblins.com/five-minutes-to-wow.md): I reflect on the subjective similarities between using AI-assistive coding tools to make software and using Tableau and Power BI to make dashboards and reports. This is a more anecdotal story than a formal article. - [Myths, Magic, and Copilot for Power BI](https://data-goblins.com/copilot-in-power-bi.md): I explain Copilot in Fabric and Copilot in Power BI, walking through what it is, how it works, and three common scenarios when it might be used. More importantly, I evaluate whether using it over other, non-AI approaches makes sense, and evaluate the current state. ## Data culture - [Fabric is a team sport](https://data-goblins.com/fabric-expert.md): I share some unfiltered thoughts about why it’s unrealistic to expect one person to know everything in Fabric, and concerns I have about unrealistic expectations being put in the market regarding Fabric. - [The Quality Problem: A Call-to-Arms](https://data-goblins.com/quality.md): I discuss why quality is a often problem for data and analytics, and how DataOps can help. - [Solve the Right Problems](https://data-goblins.com/solving-problems.md): We discuss how we might have more impact and deliver more value with data and analytics by shifting our mentality from a focus on technical problems to equal focus on technical, business and adoption problems. - [The Data Café - A Secret Sauce for Adoption](https://data-goblins.com/data-cafe.md): What kinds of things can we do to ensure adoption once the reports are live? One of the easiest ways is to host a regular “data café” surrounding the solution. In this article we examine why this is valuable. - [Designing Models and Reports for your Future Self: Part 1](https://data-goblins.com/handover.md): 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. - [Training Power BI End-Users with reporTee](https://data-goblins.com/user-training-reportee.md): Training users is important in every Power BI project. It’s particularly important when implementing Power BI, or if users are not familiar with Power BI reports. However, creating good training material is time-consuming, and difficult. In this article, I introduce reporTee, a licensed, out-of-the-box training tool to get users oriented in Power BI reports. (archived, may be out of date) - [“We need this report in Power BI”](https://data-goblins.com/report-requirements.md): I discuss 3 common approaches to collecting reporting requirements, arguing in favor of the third approach - working iteratively & collaboratively with business users to make the report. - [Dimensions of Self-Service in Power BI: Part 2 - The Dimensions of Learning](https://data-goblins.com/self-service-learning-in-power-bi.md): I write about the learning paths users take when using self-service solutions in Power BI. Specifically, I illustrate a way to conceptualize these learning paths, making it easier to segment users and create meaningful training programs. - [Dimensions of Self-Service in Power BI: Part 1](https://data-goblins.com/self-service-strategy-in-power-bi.md): I write about the options for self-service tooling in Power BI. Which tools to use for which cases, by whom & why? I've found it's helpful to visualize the different dimensions of this, to know the options & understand user skill/solution paths. - [The value Power BI could bring to Academic Research](https://data-goblins.com/power-bi-in-academic-research.md): I believe that Power BI - if successfully adopted & supported in a research department - has the potential to deliver tremendous value. In this article, I try to explain how, and why this benefits researchers & society as a whole. - [The Goblin Behind the Model](https://data-goblins.com/goblin-behind-the-model.md): We examine the importance of empathy in growing a data culture — one where others want to participate. ## Career and personal - [An update about articles on data-goblins.com](https://data-goblins.com/2024-personal-update.md): I share that I won’t publish articles about Power BI and Fabric on data-goblins.com anymore, focusing my efforts on content for Tabular Editor and SQLBI. (archived, may be out of date) - [Need some more goblins?](https://data-goblins.com/2023.md): This short update shares some content I've published elsewhere this year which you might find helpful. (archived, may be out of date) - [Does it feel like too much?](https://data-goblins.com/whats-new.md): If you feel like the pace and volume of updates surrounding Power BI have increased, you’re not alone. In this article, I discuss why many people feel like “it’s just too much” lately, why that’s a problem, and what we might do about it. - [Analyze Video Game Data for Personal Data Projects](https://data-goblins.com/video-games.md): We examine why video games provide the perfect data sources for learning Fabric, Power BI, and honing your data skills, in general. - [Playing Dungeons & Dragons was the best thing I did for my Power BI career](https://data-goblins.com/dnd.md): I share how my hobby running Dungeons & Dragons games has contributed to my personal and career development, resulting in me becoming a more competent data professional. - [Advance Your Career & Learning with Data Communication](https://data-goblins.com/data-communication.md): I share how participating in ‘data communication’ activities like blogging, speaking or making video tutorials can help you learn faster, sharing my own experiences & learnings writing articles in 2022. - [You can do this, dammit](https://data-goblins.com/mental-health.md): In recent years, mental health of professionals has become an increasing concern. Here, I share a 5-step approach to use mindfulness to combat disruptive thoughts & feelings and improve mental wellbeing. - [Looking for your input for a future session about Mental Health](https://data-goblins.com/survey-for-a-future-session.md): In October I’m presenting a session about concrete strategies for coping with challenges to personal & professional development, and mental health. For this, I’m hoping to get some input from others, which you can provide in this anonymous survey: https://forms.microsoft.com/r/iFeCxHHEV2 (archived, may be out of date) - [Sci to BI - Similarities between Science & Business Intelligence](https://data-goblins.com/sci-to-bi.md): I write about the similarities between scientific research & business intelligence.This article was originally written in 2019; I re-published it to support an article I’m working on about Power BI in Academic Research. # Portfolio ## Fabric apps - [SpaceParts OTD Command](https://data-goblins.com/portfolio/otd-command.md): A Fabric data app for on-time delivery over the SpaceParts model. This demo generates its sample data in the browser. (Power BI and Fabric, Oct 2026) ## Power BI reports - [Executive dashboard](https://data-goblins.com/portfolio/reports/executive-dashboard.md): A Power BI report built with pbir-cli on the SpaceParts sample data. (Power BI and Fabric, Sep 2026) - [Sales Analysis](https://data-goblins.com/portfolio/reports/sales-analysis.md): A Power BI report built with pbir-cli on the SpaceParts sample data. (Power BI and Fabric, Sep 2026) - [On-Time Delivery](https://data-goblins.com/portfolio/reports/on-time-delivery.md): A Power BI report built with pbir-cli on the SpaceParts sample data. (Power BI and Fabric, Sep 2026) ## Open source - [Power BI agentic development](https://github.com/data-goblin/power-bi-agentic-development): Power BI skills, subagents and hooks for Claude Code and GitHub Copilot: semantic models, DAX, TMDL, reports and Fabric. (Power BI and Fabric, Jan 2026, 1084 stars) - [Claude Code filetree](https://github.com/data-goblin/claude-code-filetree): IDE-style file tree for Claude Code: a live pane that shows which files Claude reads and edits, with git status, diffs and search. (Coding agents, Oct 2026, 391 stars) - [pbir-cli and MCP](https://github.com/maxanatsko/pbir.tools): Agent-first CLI and MCP server for Power BI report manipulation. (Power BI and Fabric, Mar 2026, 334 stars) - [FileBlade](https://github.com/data-goblin/fileblade): Customizable IDE-like sidebars for managing files and referencing information in Omarchy. (Omarchy, Sep 2026, 56 stars) - [Learn MCP servers](https://github.com/data-goblin/learn-mcp-servers): Resources and examples to learn how to use and make MCP servers for data and analytics. (Coding agents, Jul 2025, 55 stars) - [nb-cli](https://github.com/data-goblin/nb-cli): A command-line interface for notebooks in Microsoft Fabric. (Power BI and Fabric, Apr 2026, 12 stars) - [omgato](https://github.com/data-goblin/omgato): Omarchy panel for Key Lights, Stream Deck, Stream Deck Pedal and Cam Link 4K, each with a command line tool. (Omarchy, Aug 2026, 4 stars) - [pq-cli](https://github.com/data-goblin/pq-cli): Run Power Query M expressions through the Microsoft Fabric API. (Power BI and Fabric, Apr 2026, 3 stars) - [Fabric NerdFont](https://github.com/data-goblin/fabric-nf): A NerdFont with glyphs of the Microsoft Fabric icons for terminal user interfaces. (Power BI and Fabric, Oct 2026, 0 stars) - [Databricks NerdFont](https://github.com/data-goblin/databricks-nf): A NerdFont with glyphs of the Databricks icons for terminal user interfaces. (Databricks, Oct 2026, 0 stars) ## Private work - [Deckard](https://data-goblins.com/portfolio/deckard.md): An opinionated markdown-to-slides framework for building rich, web-native presentations. (Tools and Utilities, Jul 2026) - [democtl](https://data-goblins.com/portfolio/democtl.md): Records, edits and renders scripted demo videos from the terminal. (Coding agents, Aug 2026) - [astrolithography](https://data-goblins.com/portfolio/astrolithography.md): A Tauri markdown editor for writing and publishing articles, made for Tabular Editor. (Writing, Dec 2025) - [hubspot-cli](https://data-goblins.com/portfolio/hubspot-cli.md): A Rust command-line tool that publishes markdown articles to HubSpot, made for the Tabular Editor blog. (Writing, Apr 2026) ## Personal and Artwork - [Consequences of Intelligence](https://consequencesofintelligence.com): What are the consequences of AI? Will it be good or bad? Probably both. (AI safety, Oct 2026) - [Hell Must Be Empty](https://kbhm.be): A personal blog by Kurt. (Writing, Jan 2026) ## Presentations