Data Visualization · 12. November 2023
The (better) rectangular pie chart
Using Deneb helps to add the visual hints of a pie chart to a stacked bar chart.
Microsoft Fabric · 22. Oktober 2023
Select, Detect, Act, or why I consider Reflex being a watchdog
Reflex is many things next to one of the workloads of Microsoft Fabric. Before I delve into these things in more detail in later articles (yes, maybe this is the birth of another series of articles), I want to say this: Reflex is cool. It was never that simple to watch your data in your Power BI datasets (and this is only one of the capabilities of Reflex). Because I need images whenever I try to understand things, I start with a simple image of Reflex: I consider Reflex a watchdog! Reflex is...
Microsoft Fabric · 17. Oktober 2023
Power BI Gateway monitoring and more using Microsoft Fabric
No matter what, when the Power BI on-premises gateways are not working as expected, data will not refresh, and direct query queries will not succeed. It's almost simple to create a monitoring solution using Microsoft Fabric
Data Architecture · 09. Oktober 2023
Tear down walls, no data silos any longer using Microsoft Fabric, and finally, export to Excel will become a breeze
One of the many things I consider epic regarding Microsoft Fabric is the fact that the compute engines that fuel the magic of Fabric have been enabled to read natively from a new storage format. This new storage format is the delta table format (in short, CRUD-enabled parquet files).
Power BI Service · 24. September 2023
I love building Power BI solutions, solutions that help my colleagues make better decisions. I’m very much interested in the overall data architecture and love creating data models that sometimes look like a star, but they often don’t because there are more than six tables 😱. To feed these models with data, sometimes we have to do heavy data massaging, and sometimes we don’t need to. The content creation starts when the model is done (at least for a few months). This last step is often...
DAX · 17. September 2023
DAX from the trenches - how I write complex DAX statements
This article describes the process of how I solve complex DAX, of course there is some fancy DAX included.
09. September 2023
Because this is the third in the last ten years, and I consider this book special, I want to explain why love reading non-fictional books. I’m generation-reading even if I consider creating my own YouTube channel. Most of the time, I read non-fiction books. I read some books from start to end, and some I consider reference books. When reading a technical book, I can read at my speed, reread a single sentence as often as I want, and ponder each word as long as I want until the words find their...
Power BI Service · 19. August 2023
Power BI licensing, an eternal mystery, and now - there is also Fabric licensing
You have to pay for sharing. The more you want, the more you have to pay. It's about container and capabilities.
Power BI Service · 12. August 2023
I’ve turned to the dark side (dark, like black velvet), now I’m using a Macbook, or how to connect to a local SQL Server instance that is not that local
This is not only how I use a SQL Server instance with my new MacBook Pro setup, but this is also how to integrate a remote Azure SQL virtual machine into your Power BI tenant.
Power BI Service · 12. Juni 2023
Have data will travel or should I stay or should I go
We are all aware that data must travel when we want to share insights throughout the organization enabling actionable decision-making by using Power BI reports. But sometimes it's tempting to overlook some important details when it comes to data travel, these details are the distance the data must travel and crossing the border of an Azure data center. We may call it freedom when crossing a border, other may call this egress.

Mehr anzeigen