Improving Semantic Model Documentation with AI in Power BI

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

Soft deletion of workspaces and retention

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 …

Continue reading Soft deletion of workspaces and retention

Exploring Power BI Visual Calculations

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 …

Continue reading Exploring Power BI Visual Calculations

refreshdatamartsprogrammatically_featuredimage

Can you refresh a Power BI Datamart Programmatically?

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?

Tenant settings that block from adding a service principal to a workspace

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

Unveiling the Gotcha: The Hidden Consequences of Disabling Fabric in Your Organization

Recently, I had two enterprise customers with whom I was in conversation about Microsoft Fabric and how it could complement their existing data landscape. Both of these customers have a data platform running already, which have lots of best practices and customizations in it, not necessarily portable to Fabric. Also, both came from a standpoint …

Continue reading Unveiling the Gotcha: The Hidden Consequences of Disabling Fabric in Your Organization

Recover Your XMLA-Modified Power BI Semantic Models with These Git-Integration Steps

Have you ever found yourself stuck with a modified Power BI Semantic Models, thanks to those well-intentioned but troublesome changes you made through the XMLA endpoint? Does that sound familiar to you? What seemed like a convenient solution quickly turned into a frustrating challenge when you encountered the error message in the Power BI Service. …

Continue reading Recover Your XMLA-Modified Power BI Semantic Models with These Git-Integration Steps

Exploring Direct Lake Framing and warm-up data using Semantic Link in Fabric Notebooks

In the previous blog, I wrote about data temperature as part of Fabric when you're using Direct Lake storage mode. In that blog, I explained how you can get insights in the temperature of a column, what that temperature means and what the impact of the temperature is on columns that are queried more often. …

Continue reading Exploring Direct Lake Framing and warm-up data using Semantic Link in Fabric Notebooks

Understanding data temperature with Direct Lake in Fabric

As part of Microsoft Fabric, a new storage mode to connect from Power BI to data in OneLake has been introduced. Direct Lake it makes to possible to use your data from OneLake in Power BI without taking an additional copy of the data. Where Direct Lake promises to deliver the performance of Import-mode with …

Continue reading Understanding data temperature with Direct Lake in Fabric

Add service principal to Fabric workspace using Power BI REST API

Lately, I found myself struggling using the Power BI REST API to add a service principal to the (Fabric) workspace. After I engaged with some other folks, I managed to succeed. In this blog I will elaborate on the mistake I made and how I got it to work. For some this might be a …

Continue reading Add service principal to Fabric workspace using Power BI REST API