Data Goblins Blog — DATA GOBLINS

All in Data Visualization

Apr 5

Apr 5 Track Changes in Power BI: Part 5 - Using pbi-tools

Data Visualization, Governance/Administration

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

Mar 29

Mar 29 Track Changes in Power BI: Part 4 -Reports

Kurt Buhler

Data Visualization, Governance/Administration

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.

Jan 18

Jan 18 How to hide blanks in Cards & KPI visuals in Power BI, easily

Kurt Buhler

Data Visualization

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.

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.

Feb 16

Feb 16 Visualizing Microsoft Planner & Tasks data in Power BI

Kurt Buhler

Getting/Transforming Data, Data Visualization

In this article we look at how to get Microsoft Tasks / Planner data into Power BI, to make analytical reports from our operational Planner boards.

Oct 17

Kurt Buhler

Data Visualization

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