Automation — Data Goblins Blog

All tagged Automation

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.

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.

Oct 18

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

Kurt Buhler

Data Modelling

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.

Apr 19

Apr 19 Extracting Power BI Tenant Settings with Power Automate Desktop

Kurt Buhler

Power BI, Governance/Administration

In this post, 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.

Mar 2

Mar 2 Automated Regression Monitoring in Power BI

Kurt Buhler

Governance/Administration, Data Visualization

In this article, we examine a method to automatically monitor & test data quality in Power BI by setting up a composite model to detect data changes.