Integrate Power BI Deployment Pipelines with Azure DevOps

Back in 2019, Ton Swart and I wrote a blog post on Versioning and CI/CD for Power BI with Azure DevOps. Back then, there were not many options available for versioning and professionalizing your ALM story for Power BI. Till today, this blog post is still my most read blog on Data-Marc.com which makes us …

Continue reading Integrate Power BI Deployment Pipelines with Azure DevOps

My favorite Power BI announcements from the Business Application Summit

Missed the announcements from the Microsoft Business Application Summit? With this post I want to share the, what I believe, are the most exciting and impactful updates for Power BI that are announced during Microsoft Business Application Summit. Below a brief summary of what’s coming and why this is so super exciting! FastTrack Recognized Solution …

Continue reading My favorite Power BI announcements from the Business Application Summit

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

Proud and humbled! Recognized as FastTrack Recognized Solution Architect

I'm proud and humbled to share that I have received a recognition as FastTrack Recognized Solution Architect among 32 others worldwide. After submitting my profile and passing the review process by the Power Platform engineering team and the Power BI Customer Advisory Team (CAT), I received this amazing news. This recognition stands for "practicing solution …

Continue reading Proud and humbled! Recognized as FastTrack Recognized Solution Architect

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

Trigger a single table to refresh in the Power BI Service

If you want to refresh a Power BI dataset, we all know where to find the refresh button in Power BI Desktop as well as in the Power BI Service. By clicking it, you will trigger the entire dataset to refresh. But sometimes it is more convenient to trigger a single table to refresh. If …

Continue reading Trigger a single table to refresh in the Power BI Service

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!

Improve my home office setup

As it is not likely that anything will change anytime soon, we are probably working from home for the coming period. Although I had a pretty good home office already and not much to complain about, still I decided to up my game and upgrade my home office. You might think, "huh... normally he writes …

Continue reading Improve my home office setup

Extract refresh metrics for your entire Power BI workspace

In the Power BI service, you can easily look at refresh times for an individual dataset or dataflow. There are many different reasons why these metrics are important to you as a dataset or dataflow owner. For example, you may bump into refresh time-outs or unfortunate errors. There are many good reasons to think about …

Continue reading Extract refresh metrics for your entire Power BI workspace

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