Recently, I architected a solution for a client for their Microsoft Fabric data platform. The client works with Dynamics Finance & Operations as one of their main ERP system. Fabric offers easy ways to bring data from various standard Microsoft services into the platform, however it is not always as easy as it looks like. …
Continue reading Gotcha’s of bringing Dataverse data into Microsoft Fabric
I've heard the question pretty often from customers: "You told me to use incremental refresh, but how can I regularly run a full load or refresh onder partitions?" Well, there are perfect ways to do this using Tabular Editor or SQL Server Management Studio. But this often includes manual work to trigger the processing. Today, …
It has been roughly two years since the last update on the Power BI Model Documenter, an external tool that I developed to auto-document Power BI Semantic Models. Back then, we still called it datasets though. Looking at the stats of my website, the model documenter and related posts/pages are still most read on my …
Continue reading Improving Semantic Model Documentation with AI in Power BI
Recently, Microsoft released a new activity type to trigger Power BI Semantic Model refreshes. A great step forward to have a native pipeline activity and no longer need to setup complex steps with APIs and authentication manually. Or is there still a case? In this blog I will elaborate on what this new Pipeline activity …
Continue reading Orchestrate Power BI Semantic model refreshes through Fabric Pipelines
This morning, I was looking for a specific tenant setting in the Fabric admin portal. While scrolling through a few of the tenant settings, I came across a specific one, which I like to elaborate on a bit more in detail, given I recently also had some questions around this topic from customers. What happens …
Lately it's copilot before and after in all Microsoft communications and announcements. Also, during the Fabric Community Conference in Las Vegas where I was last week, it was hard to keep count of the number of times copilot was mentioned. Next to Microsoft communications, everyday conversations with customers and colleagues include copilots everywhere too. Which …
Continue reading Copilot or autopilot? Unpopular opinions on copilot
You might have seen some buzz around already, although the official blog post is not out yet, the February release of Power BI desktop is already available to download. After a month waiting (traditionally, there is no January update) it has some great new features in it! Not only Tabular Model Definition Language is there …
Last week, I was attending and speaking at the first ever Fabric February, a great in-person conference dedicated to Microsoft Fabric taking place in Oslo - Norway. (I recommend attending future editions of this event!) During the conference, someone walked up to me and asked if I knew a way to programmatically refresh Power BI …
Continue reading Can you refresh a Power BI Datamart Programmatically?
Recently, I was on a call with a good friend and former colleague, just to exchange some thoughts, knowledge and ideas. We shared some things we're working on and what we think of the evolvement of technology in the Era of AI - with the launch of Microsoft Fabric versus the technology we were used …
Continue reading Anchored vs. Active – Categorizing Technology
Today, I run into an issue by adding a service principal to a workspace. To my experience so far, this should be straight forward and a matter of adding with the right permissions in the workspace settings. However, for some reason I couldn't get it to work. In this blog I will elaborate on what …
Continue reading Tenant settings that block from adding a service principal to a workspace
Data - Marc 