How OFFSET in DAX will make your life easier

Over the past few days, I attended the Power BI Next Step conference in Lego land - Denmark. During the keynote, Will Thompson - PM on the Power BI team, showed a new DAX function that is available to all of us already, but was very well hidden in the latest builds of Power BI …

Continue reading How OFFSET in DAX will make your life easier

How to add DTAP stage identifiers of to your Power BI report with Smart Narratives

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 development, test, acceptance and production stages from each other. But as you don't want to be the only one that has …

Continue reading How to add DTAP stage identifiers of to your Power BI report with Smart Narratives

Sharing individual Power BI dataflows, but how?

Recently, I have had a challenge at a customer, where a central teams maintains many dataflows in Power BI, to store their only and single version of the truth. However, this central team maintained many different dataflows in a single workspace, but did not want to share the entire workspace with others. What now? How …

Continue reading Sharing individual Power BI dataflows, but how?

Power BI Model Documenter v2

Back in 2020, I released the first version of the Power BI external tool to document your Power BI data model. Since then, I wrote a lot about this topic, such as why adding descriptions to everything is important and various releases of the model documenter. Users encountered various challenges with the initial release of …

Continue reading Power BI Model Documenter v2

Jump from one Power BI report to another by using cross-report drill through

It is very common to have multiple reports for different audiences, while there is also one (group of) user(s) that requires to have an overview over all these different insights. The main challenge you will face, is having cross-report interactivity and find related insights. Let's take an example of three different roles, where we have …

Continue reading Jump from one Power BI report to another by using cross-report drill through

Webinar Data Modeling 101: Increasing the impact of Power BI

A decent data model is the key to success in Power BI. As this an underexposed topic in the end-to-end story of Power BI, Jeroen ter Heerdt (Program Manager on the Power BI team) and I believed it is time to change this! Wednesday, 17th of March, the first episode in a series of webinars …

Continue reading Webinar Data Modeling 101: Increasing the impact of Power BI

Add descriptions for everything you create in Power BI!

I strongly believe that it is key to describe everything that you have built as part of your Power BI model. As we all have a hate-love relationship with documenting our work, the external tool that I build to document your Power BI solutions could come in useful. In particular everything you add and only …

Continue reading Add descriptions for everything you create in Power BI!

Power BI Model Documenter v1.2.0

Time fore new enhancements to the Power BI model Documenter tool! I just presented the new enhanced version of the Power BI model Documenter at the Dutch Power BI User group. Soon, there will also be a recording online of the presentation that I will add to this post as soon as it is available. …

Continue reading Power BI Model Documenter v1.2.0

Will query folding apply to Power BI Composite models?

Recently, I run into a case where we wanted to combine Direct Query sources with imported data. Well, this functionality is actually called composite models nowadays. Having that said, let me start with managing some expectations for this post. The title says composite models, but I have to admit, it is not about the to …

Continue reading Will query folding apply to Power BI Composite models?

[UPDATED] Power BI icon for Diagrams.net to draft full Power Platform Solutions

It is only a week ago when I posted the icon library for diagrams.net, also known as draw.io, wrote a blog about it and shared with all of you. Now it is already time to give it the first update! At Ignite 2020, Microsoft showed us the new Power Platform Icons for the very first …

Continue reading [UPDATED] Power BI icon for Diagrams.net to draft full Power Platform Solutions