Macro — Data Goblins Blog — DATA GOBLINS

Plenty to read!

October 2024
- Oct 1, 2024 Recover Power BI reports or models that you can’t download Oct 1, 2024
- Oct 1, 2024 Fix visuals, replace fields, and mass-format reports in Power BI Oct 1, 2024
- Oct 1, 2024 Managing Power BI reports or models using semantic-link-labs Oct 1, 2024
September 2024
- Sep 5, 2024 Myths, Magic, and Copilot for Power BI Sep 5, 2024
April 2024
- Apr 16, 2024 Fabric is a team sport Apr 16, 2024
February 2024
- Feb 27, 2024 What Microsoft Fabric means for your semantic models: New options and approaches Feb 27, 2024
- Feb 27, 2024 What Microsoft Fabric means for your semantic models: Scenario 1 Feb 27, 2024
- Feb 27, 2024 What Microsoft Fabric means for your semantic models: Scenario 2 Feb 27, 2024
- Feb 27, 2024 What Microsoft Fabric means for your semantic models: Scenario 3 Feb 27, 2024
January 2024
- Jan 30, 2024 Fix Power BI “Something is wrong with one or more fields” Jan 30, 2024
- Jan 4, 2024 The Quality Problem: A Call-to-Arms Jan 4, 2024
December 2023
- Dec 19, 2023 Need some more goblins? Dec 19, 2023
October 2023
- Oct 18, 2023 Case-sensitive models in Power BI: consequences & considerations Oct 18, 2023
- Oct 17, 2023 How to use Tableau with Power BI and Fabric Oct 17, 2023
- Oct 8, 2023 Does it feel like too much? Oct 8, 2023
September 2023
- Sep 5, 2023 KPIs and cards in Power BI Sep 5, 2023
August 2023
- Aug 29, 2023 How to set table or matrix column widths in a Power BI report Aug 29, 2023
- Aug 22, 2023 Analyze Video Game Data for Personal Data Projects Aug 22, 2023
- Aug 2, 2023 Solve the Right Problems Aug 2, 2023
- Aug 1, 2023 Format Power Query in Power BI (Updated) Aug 1, 2023
July 2023
- Jul 28, 2023 Basic Line Charts in Power BI Jul 28, 2023
- Jul 26, 2023 Bar Charts in Power BI Jul 26, 2023
- Jul 11, 2023 Playing Dungeons & Dragons was the best thing I did for my Power BI career Jul 11, 2023
May 2023
- May 28, 2023 DAX.do quiz May 28, 2023
- May 24, 2023 Overview of new Microsoft Fabric Power BI Announcements May 24, 2023
April 2023
- Apr 25, 2023 How to unlock new features in Power BI datasets managed with Tabular Editor Apr 25, 2023
- Apr 4, 2023 How to manage “Reporting Objects” in a Power BI Dataset Apr 4, 2023
March 2023
- Mar 7, 2023 Learn Tabular Editor with a Quiz (using a C# Script / Macro!) Mar 7, 2023
- Mar 3, 2023 Snek! The First Video Game for Tabular Editor 3. Mar 3, 2023
February 2023
- Feb 28, 2023 “It Depends” - Power BI Best Practices & Optimizations Feb 28, 2023
- Feb 14, 2023 Check & Query Data from Tabular Editor Feb 14, 2023
- Feb 7, 2023 Smart Buttons & Power BI Reporting Feb 7, 2023
January 2023
- Jan 5, 2023 Run Tabular Editor Macros with Keyboard Shortcuts & Toolbar Buttons Jan 5, 2023
- Jan 5, 2023 Count Measures in Power BI Datasets with Tabular Editor Jan 5, 2023
- Jan 3, 2023 Advance Your Career & Learning with Data Communication Jan 3, 2023
December 2022
- Dec 27, 2022 Learn Power BI with Sample Datasets: Part 2 - Personal Data Projects Dec 27, 2022
- Dec 20, 2022 Learn Power BI with Sample Datasets: Part 1 - Contoso Data Generator Dec 20, 2022
November 2022
- Nov 15, 2022 Power BI Analyze-in-Excel Checklist Nov 15, 2022
- Nov 8, 2022 Measure Selection in Power BI Nov 8, 2022
October 2022
- Oct 25, 2022 The Data Café - A Secret Sauce for Adoption Oct 25, 2022
- Oct 18, 2022 Converting a Power BI Dataset .bim to a .pbix with pbi-tools Oct 18, 2022
- Oct 18, 2022 Power BI App Checklist Oct 18, 2022
- Oct 18, 2022 Power BI Dashboard Checklist Oct 18, 2022
- Oct 18, 2022 Power BI Dataflow Checklist Oct 18, 2022
- Oct 4, 2022 Power BI Data Visualization - Ideas & Wishlist Oct 4, 2022
September 2022
- Sep 6, 2022 Exploring App Audiences in Power BI Sep 6, 2022
- Sep 1, 2022 Power BI Dataset Checklist Sep 1, 2022
- Sep 1, 2022 Power BI Report Checklist Sep 1, 2022
August 2022
- Aug 30, 2022 Designing Models and Reports for your Future Self: Part 1 Aug 30, 2022
- Aug 23, 2022 You can do this, dammit Aug 23, 2022
July 2022
- Jul 28, 2022 Looking for your input for a future session about Mental Health Jul 28, 2022
- Jul 26, 2022 Training Power BI End-Users with reporTee Jul 26, 2022
- Jul 19, 2022 “We need this report in Power BI” Jul 19, 2022
- Jul 5, 2022 Disable Auto-scaling in Power BI Visuals Jul 5, 2022
June 2022
- Jun 28, 2022 Visualize Power BI Dependencies with Tabular Editor and Mermaid Jun 28, 2022
- Jun 21, 2022 Dimensions of Self-Service in Power BI: Part 2 - The Dimensions of Learning Jun 21, 2022
- Jun 21, 2022 The Impact Factor of Power BI External Tools Jun 21, 2022
- Jun 14, 2022 Dimensions of Self-Service in Power BI: Part 1 Jun 14, 2022
- Jun 7, 2022 The value Power BI could bring to Academic Research Jun 7, 2022
May 2022
- May 31, 2022 Sci to BI - Similarities between Science & Business Intelligence May 31, 2022
- May 24, 2022 Can't Enable Audit Log in Office Compliance Portal May 24, 2022
- May 17, 2022 Monitoring Power BI using REST APIs from Python May 17, 2022
- May 10, 2022 Fix Visuals or Replace Measures in Power BI Reports using pbi-tools May 10, 2022
- May 9, 2022 Get Power BI Dataset Refresh History using Python May 9, 2022
- May 8, 2022 Get Publish-to-Web & Org. share links from Power BI API with Python May 8, 2022
- May 7, 2022 Get Workspaces from Power BI API with Python May 7, 2022
- May 6, 2022 Get Deployment Pipelines from Power BI API with Python May 6, 2022
- May 5, 2022 Formatting Code for Blogs & Websites May 5, 2022
- May 1, 2022 Running PowerShell from a Python GUI May 1, 2022
April 2022
- Apr 19, 2022 Extracting Power BI Tenant Settings with Power Automate Desktop Apr 19, 2022
- Apr 12, 2022 Adding tables in Power Query using Tabular Editor Apr 12, 2022
- Apr 5, 2022 Track Changes in Power BI: Part 5 - Using pbi-tools Apr 5, 2022
March 2022
- Mar 29, 2022 Track Changes in Power BI: Part 4 -Reports Mar 29, 2022
- Mar 15, 2022 Assess an Existing Dataset with Tabular Editor 3 - Part 3: Extend DMVs with C# Scripts & Macros Mar 15, 2022
- Mar 8, 2022 Assess an Existing Dataset with Tabular Editor 3 - Step 2: Query DMVs Mar 8, 2022
- Mar 1, 2022 Analyze a Dataset with Tabular Editor 3 - VertiPaq Analyzer Mar 1, 2022
February 2022
- Feb 22, 2022 The Goblin Behind the Model Feb 22, 2022
- Feb 15, 2022 How to Analyze YouTube & YouTube Music History with Power BI (or Excel) Feb 15, 2022
- Feb 8, 2022 View & Edit Power Query in Tabular Editor Feb 8, 2022
- Feb 1, 2022 Track Changes in Power BI: Part 3 - Workspace Mode Feb 1, 2022
- Feb 1, 2022 Track Changes in Power BI: Part 2 - Tutorial Feb 1, 2022
- Feb 1, 2022 Track Changes in Power BI: Part 1 - Introduction Feb 1, 2022
January 2022
- Jan 25, 2022 A Beginner's Guide to Tabular Editor 3: UI Customization & Code Assist Features Jan 25, 2022
- Jan 20, 2022 How to create an Azure DevOps Repo using Git & Visual Studio Jan 20, 2022
- Jan 18, 2022 How to hide blanks in Cards & KPI visuals in Power BI, easily Jan 18, 2022
- Jan 11, 2022 Tabular Editor - Which License is Right for You? An Interactive Guide. Jan 11, 2022
- Jan 4, 2022 Tabular Editor – Supercharge your Power BI Development Jan 4, 2022
December 2021
- Dec 28, 2021 Format all DAX in your model at once with Tabular Editor Dec 28, 2021
March 2021
- Mar 2, 2021 Automated Regression Monitoring in Power BI Mar 2, 2021
February 2021
- Feb 16, 2021 Visualizing Microsoft Planner & Tasks data in Power BI Feb 16, 2021
October 2020
- Oct 17, 2020 How to make effective slope charts in Power BI Oct 17, 2020
- Oct 10, 2020 How to make a Waffle chart without custom visuals in Power BI Oct 10, 2020
- Oct 6, 2020 How to label the latest data point in a Power BI line or area chart Oct 6, 2020
September 2020
- Sep 15, 2020 Selectable dimensions in Power BI Sep 15, 2020
- Sep 8, 2020 What are 'Details-on-Demand' matrixes in Power BI? Sep 8, 2020
August 2020
- Aug 25, 2020 KPI Tab page navigation in Power BI Aug 25, 2020

All tagged Macro

Format Power Query in Power BI (Updated)

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.

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

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.

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

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!

Snek! The First Video Game for Tabular Editor 3.

Mar 3

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

Other Topics, Non-Technical Topics

This article is a fun one-off sharing a Tabular Editor C# script to play a Snake game.

Check & Query Data from Tabular Editor

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.

Run Tabular Editor Macros with Keyboard Shortcuts & Toolbar Buttons

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.

Count Measures in Power BI Datasets with Tabular Editor

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.