Connect the Power BI Model Documenter to existing data models in the Power BI Service or Analysis Services

Recently, I've published a new version of the Model Documenter. With that, version 2.1.0 went live. I always try to keep the FAQ up to date and add sections describing typical questions and use cases. However, sometimes it is just easier to write a blog about it to reach a bigger audience, or even record …

Continue reading Connect the Power BI Model Documenter to existing data models in the Power BI Service or Analysis Services

Power BI Model Documenter v2.1.0

It is long overdue, but time for a new updated version for the Power BI Model Documenter external tool! The latest release lasts from the first week of 2022 and since then close to 6000 people have downloaded the Model Documenter installer directly from the website, excluding the downloads and clones from the GitHub repository. …

Continue reading Power BI Model Documenter v2.1.0

Effect of dataset changes while using deployment pipelines in Power BI

This week, I've presented at two conferences in Europe about Application Lifecycle Management for Power BI. During these sessions at DataMinds Connect and Techorama I've talked and demoed native Power BI deployment pipelines, as well as Azure DevOps integration. One of the topics discussed during the session, is the effect of deployments on datasets by …

Continue reading Effect of dataset changes while using deployment pipelines in Power BI

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

Power BI Datamarts, should I use it or not?

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 about Power BI Datamarts, I thought lets do it! They convinced me that it would be a …

Continue reading Power BI Datamarts, should I use it or not?

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

What you must know when building Power BI dataflows routing over the on-premises data gateway

Another week, another challenge! Summer holidays is the perfect time to run into challenges that you normally would not encounter or simply do not know about because they are fixed before you know. This blog will elaborate on a case I had at a client, where we run into issues with the on-premises data gateway …

Continue reading What you must know when building Power BI dataflows routing over the on-premises data gateway

Add user to Power BI deployment pipeline using REST APIs

Especially in this time of the year, you will encounter many similar kind of questions as a Power BI Service Administrator. Questions like: "My colleague is on vacation, but I don't have access to the workspace and the refresh broke, can you help me getting access to this workspace?" Well, this is still the simple …

Continue reading Add user to Power BI deployment pipeline using REST APIs

Nomination as Dutch IT Talent – vote for me!

This time a slightly different post. Not Power BI or Microsoft related. Though I would like to ask you to read on cause I need your help! I'm proud to announce that I'm nominated as Dutch IT Talent of the year 2022 by Computable. Cause with only the nomination I'm not there yet. Now, I …

Continue reading Nomination as Dutch IT Talent – vote for me!

Power BI B2B External Collaboration

You might have seen the recent YouTube video by Guy in a Cube, where Adam explains how to work as an external user and publish content from Power BI Desktop to a B2B workspace. In this blog, I will further elaborate on business-to-business capabilities of Power BI, some related tenant settings that allows or blocks …

Continue reading Power BI B2B External Collaboration