Power BI Report — Data Goblins Blog

All tagged Power BI Report

Oct 1

Oct 1 Recover Power BI reports or models that you can’t download

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

Oct 1

Oct 1 Fix visuals, replace fields, and mass-format reports in Power BI

Kurt Buhler

Data Visualization

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

Oct 1

Oct 1 Managing Power BI reports or models using semantic-link-labs

Kurt Buhler

Data Modelling, Data Visualization, External Tools

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

Oct 4

Oct 4 Power BI Data Visualization - Ideas & Wishlist

Kurt Buhler

Data Visualization

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?

Sep 1

Sep 1 Power BI Report Checklist

Kurt Buhler

Data Visualization

In this post I list some tips for checking to make sure your report is ready for handover to someone else.

Jul 19

Jul 19 “We need this report in Power BI”

Kurt Buhler

Data Culture & Adoption, Data Visualization

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

Jul 5

Jul 5 Disable Auto-scaling in Power BI Visuals

Kurt Buhler

Data Visualization

‘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.

Jun 14

Jun 14 Dimensions of Self-Service in Power BI: Part 1

Kurt Buhler

Data Culture & Adoption, Governance/Administration

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

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

Oct 17 How to make effective slope charts in Power BI

Kurt Buhler

Data Visualization

Oct 10

Oct 10 How to make a Waffle chart without custom visuals in Power BI

Kurt Buhler

Data Visualization

In this article we look at a method for creating waffle charts in Power BI with the default visuals.

Oct 6

Oct 6 How to label the latest data point in a Power BI line or area chart

Kurt Buhler

Data Visualization

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

Sep 8

Sep 8 What are 'Details-on-Demand' matrixes in Power BI?

Kurt Buhler

Data Visualization

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

Aug 25

Aug 25 KPI Tab page navigation in Power BI

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.