# Archived articles

These articles are considered outdated and not indexed as part of my main writing corpus. They're here only for documentation and reference purposes.

## Semantic models

- [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)
- [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)

## Reports and 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)
- [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 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

- [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)
- [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)
- [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)
- [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)

## Data culture

- [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)

## 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)
- [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)

## Portfolio

- [Data Goblins Flash Report](https://data-goblins.com/portfolio/reports/flash-report.md): A month-to-date flash report with a volcano plot, on the SpaceParts sample data. (Power BI and Fabric, Aug 2022)
- [Power BI MacGuyver toolbox](https://github.com/data-goblin/powerbi-macguyver-toolbox): Power BI report templates and patterns to create special visuals and solve specific problems. (Power BI and Fabric, Jul 2023)
- [Tabular Editor quiz](https://github.com/data-goblin/TabularEditorQuiz): A quiz for learning Tabular Editor. (Power BI and Fabric, Mar 2023)
- [Digital Shadow Project](https://images.data-goblins.blog/downloads/Digital-Shadow.pdf): Two years of my own data from 13 sources, extracted with Python and visualized in Power BI. (Power BI and Fabric, Dec 2020)
- [The Adventures of Klonk, Part 1: DataVis Best Practices](https://www.youtube.com/watch?v=V8vGoxx2q0Q): How can we design reports that follow best practices and meet end-user needs? A talk given at DataMinds Connect virtual conference (Presentations, Oct 2020)
- [The Adventures of Klonk, Part 2: Report Adoption](https://www.youtube.com/watch?v=zy-EDipDnW8): How can we ensure successful adoption of our report? This talk is all about measuring & monitoring success in a reporting project. A talk given at DataMinds Saturday virtual conference. (Presentations, Mar 2021)
- [The Adventures of Klonk, Part 3: Data Literacy](https://www.youtube.com/watch?v=tg4gX-84FAs): Does data literacy affect business effectiveness? Yes it certainly does. With a deep-dive case study of Sales Compensation Plans, this talk examines the impact Data Literacy can have in an organization, and what we can do to improve data literacy to create more sustainable data solutions and cultures. (Presentations, Apr 2022)
