Power BI

Field parameters are great for dynamic legends, but the creation of a dyanmic measure + time intel chart can be time consuming. Most of it can be automated.

When it comes to Snowflake, data sharing is one of the important features that stands out from other competitors. This feature is so catchy as data sharing is something most organizations are strug…

This is the fourth and the last article on the EvaluateAndLog function. While DAX developers were excited about the prospect of printing the values of a portion of a DAX expression, many of the ear…

In this blog post, I'm going to share with you a recent success story from one of my customers. For privacy reasons I can't mention the customer itself, but I will give you a little overview of the company and the kind of industry they are in. With this success story, I hope I can inspire readers and customers to think more carefully about their design choices when building reports in Power BI. COMPANY OVERVIEW Customer: Recruiting Analytics (for privacy reasons, I can't reveal the real name of

You want to return the nth business day from a date in Power Query. And this offset should take into account holidays and weekends. It's a common requirement

Learn how to use Timeline Visual in Power BI to show data per date in a timeline format | Horizontal Timeline in Power BI | Virtical Power BI Timeline visual

This article provides information on how to enable query folding against queries that use the Value.NativeQuery function.

With conditional formatting and a few calculation groups it's possible building a fading bar chart, even assigning colors to categories by code.

The task of creating calculation groups to active calculation groups can be automated with a C# Script. This script contains custom classes.

If you are a Power BI report developer, you might have experienced the case I’m describing in this post. You did your utmost best to setup a decent DT(A)P process, where you clearly separate …

Last months I did a presentation for the well-known Club Power BI (Brussels). This session was a brief listing of the most exciting External tools / Third-party software that can help us to work with Power BI. As a Power BI passionate guy, I wanted to be sure to show and explain my favorite applications. […]

I explained what SCD means in a Business Intelligence solution in my previous post. We also discussed that while we do not expect to handle SCD2 in a Power BI implementation, we can handle scenarios similar to SCD1. In this post, I explain how to do so. Scenario We have a retail company selling products. … Continue reading Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1

How to show almost 200 countries data on a treemap visual? For this experiment I took international trade statistics (merchandise exports by product group, annual) … Read More

Hear about the latest updates to Datamart in Power BI since the //Build announcement

In the last post I went over using Power Automate to perform a data driven report subscription using a Paginated report referencing an AAS database. The flow referenced an Excel file with the infor…

In the July 2022 Power BI update, they updated the Dataverse connector. The connector now uses the display names from a Dataverse table.

We’re thrilled to announce that a new component for embedding Power BI content in Vue.js applications is now available! Vue is an increasingly popular JavaScript framework for building front-end user interfaces and websites.

In the last post I went over using Power Automate to perform a data driven report subscription using a Paginated report referencing a Power BI dataset. The flow referenced an Excel file with the in…

Explore what data clean rooms are, why they're important, and how your organization can implement them in Snowflake - all in this blog!

We are very pleased to announce the introduction of AAD-based filtration to the Power BI Datamarts tenant setting.

Explore 8 essential steps that will help healthcare organizations plan and build a foundation for an actionable data strategy framework.

The first post after my vacation. I was in doubt for a while whether I should write this one or not… given the preview state. Since one of the customers I work for asked me for advise today a…

Yesterday I was facing an annoying issue. I have two Power BI datasets. Both connect to the same Azure SQL database, but with different SQL users (they have both different permissions on the data in the database). This can be a use case for example where you have data for multiple clients inside one

Welcome to the September 2022 update. We are thrilled to announce a variety of new features such as hierarchical axis by default, translations for composite models, mobile formatting options general availability and cross tenants’ datasets sharing. There is more to explore, please continue to read on.

Using the new Power BI Audiences with AAD Security Groups for easier management of reports/dashboards for users.

I came across this Global Views on Abortion Report which showed the following graph: It was great to compare support for permitting abortion across different countries, but it was a little more difficult to compare support for not permitting abortion across countries. So I thought I’d have a go at modifying the chart slightly. From… Continue reading Quick Chart Makeover

In this post I will go over a topic that is frequently asked about and that is using a Service Principal account with Power BI when connecting to data sources. Currently today none of the built-in …