Power BI

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.

Recursive flows in Power Automate can be established using variables. Both loop types "Do-until" and "Apply-to-each" cover typical scenarios.

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 …

The Power Platform Landing Zone is the beginning of the path to overcoming these barriers. A foundation, if you will, the Landing Zone is the initial technical infrastructure plus governance of that infrastructure that allows an organization to begin “landing” workloads in Power Platform. With that

All Power Apps forms should perform data validation, have error handling, protect against lost of unsaved data and restrict input values.

Under cat-struction. Coming soon.

Learning to consume APIs in Power BI has been a game-changer for me. As I started making my first API requests, a world of…

In this article, we explore Power BI App Audiences and why they are such a powerful feature for managing and using content in Power BI Apps.

DataOps Principle #10: Orchestration

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 …

One approach to optimise DAX queries is to focus on the number of Storage Engine (SE) calls generated by a query and look for ways to provide the same result using fewer SE calls. If a query takes 30 seconds to run and makes hundreds of SE calls, reducing the number of SE calls almost … Continue reading DAX 1-Column Fusion

What if I tell there is a way to show only the desired data labels in PowerBI and that is without any extra visuals? It can be applied to almost all the visuals I tried, just need to write DAX. There are two tricks I have used here the first trick I came across was by luck, and I am not sure if anyo

The Ultimate EPL Fantasy Football Report!