Press "Enter" to skip to content

Category: Power BI

Refreshing a Power BI Semantic Model via Fabric Pipelines

Published 2024-04-18 by Kevin Feasel

Marc Lelijveld builds a pipeline:

Recently, Microsoft released a new activity type to trigger Power BI Semantic Model refreshes. A great step forward to have a native pipeline activity and no longer need to setup complex steps with APIs and authentication manually. Or is there still a case?

In this blog I will elaborate on what this new Pipeline activity exactly is, various scenarios in which it can be applied and finally some edge cases and shortcomings.

Click through to see how it works.

Leave a Comment

Creating DAX Measures Directly in the Power BI Service

Published 2024-04-10 by Kevin Feasel

Gilbert Quevauvilliers skips the desktop step:

There have been some updates to Power BI with Visual Calculations, and as of the March 2024 release you can now create and edit visual calculations in the Power BI Service.

Here are details from the blog post: Power BI March 2024 Feature Summary | Visual Calculations Update

I then saw an email which made me think, could I then use the visual calculations to create a DAX measure directly in the Power BI Service on an existing Power BI report.

The answer, it turns out, is yes. Read on to see how.

Leave a Comment

EXPAND() and COLLAPSE() in Power BI Visual Calculations

Published 2024-04-09 by Kevin Feasel

Marco Russo and Alberto Ferrari play the accordion:

In previous articles, we introduced the concepts of visual context, the visual lattice, and the two visual context navigation operations: EXPAND and COLLAPSE. In this article, we build on that knowledge to first compute a simple percentage over the parent: a simple calculation to consolidate the understanding of EXPAND and COLLAPSE. Next, we move on to a much more complex scenario, computing the inflation-adjusted sales using visual calculations.

Read on to see what the two functions do, using a pair of examples.

Leave a Comment

Migrating Power BI Semantic Models to Direct Lake

Published 2024-04-08 by Kevin Feasel

Nikola Ilic performs a migration:

Here is my scenario: there is an existing Power BI semantic model in import mode (in reality, there are many of them, but for the sake of keeping things simple for this blog post, let’s pretend that there is only one semantic model to be migrated).

Click through to see what the current state of the semantic model looks like, as well as the way to migrate. It’s not trivial, but Nikola does take us through it step by step.

Leave a Comment

Accessibility Features in Power BI

Published 2024-04-08 by Kevin Feasel

Elena Drakulevska takes us through some of the accessibility features in Power BI:

As data professionals, we’re constantly striving to create reports that effectively communicate insights to our audience. Did you know that within Power BI, there are hidden accessibility features that can enhance the usability for all users—with minimal effort on your part? Today, we’re digging into this overlooked aspect of Power BI and exploring how these features can elevate your data visualization projects.

Click through for three features.

Leave a Comment

Displaying Azure Maps within a Power BI Paginated Report

Published 2024-04-08 by Kevin Feasel

Chris Webb shows a map in a paginated report:

The built-in mapping functionality in Power BI paginated reports is fairly basic. However the integration of Power Query into Power BI paginated reports gives you an interesting new way of creating maps in paginated reports: you can call the Azure Maps API using Power Query and display the image returned in an Image report item. In this blog post I’ll show you how.

Click through for the demo.

Leave a Comment

The Power of the (Scatter) Plot

Published 2024-04-05 by Kevin Feasel

Kurt Buhler digs into scatter plots:

In many reports, it is common to find large tables or matrixes with a lot of information. Business users come to these reports to get the details they need to answer questions, make decisions, and take actions. However, these detailed tables can be inefficient, requiring users sort, drilldown, and filter them to find actionable data.

Consider the following example of a matrix to analyze gaps in year-over-year growth by product, and dissect those by region. In this scenario, the intended purpose of the report is for a sales team to analyze why we did not hit our revenue growth target.

Read on to learn what you can do with a scatter plot, either natively in Power BI or via custom visual.

Leave a Comment

A Review of Powerops

Published 2024-04-05 by Kevin Feasel

Nikola Ilic reviews a new tool:

In the last 2-3 months, I had an opportunity to try and test the new external tool, called Powerops. This is an external tool developed by Truviz, the company you might already know as the creators of various Power BI “goodies”.

Now, you are probably expecting “another Power BI external tool that solves a specific challenge”…I’ll tell you straight away – you can’t be more wrong! Powerops is a mix of various existing external tools – think of DAX Studio, Tabular Editor, ALM Toolkit, Measure Killer, etc. – but it’s also more than a simple sum of the features of the aforementioned tools.

Read on for the full review. Pricing is free for the first two months, and then either buy a license or you can upload up to two files per month and remain in the free tier.

Leave a Comment