How to use Microsoft Purview Protection Policies so a Fabric workspace Admin can still fully administer the workspace… but is completely blocked from seeing any of the sensitive data inside it. You keep the person as Admin (so they can manage items, permissions, capacity, etc.) while the protection policy + sensitivity label combination simply removes their ability to open or…

In this blog post I’m going to show you how you can use variable libraries with connection strings as well as items. This approach allows you to manage environment-specific configuration when deploying Fabric items across development, test, and production workspaces If you’re looking to move your fabric capacities across workspaces or regions, you can do this quickly and easily without…

In this blog post I am going to show you how to use a Fabric Python runtime notebook (This is the notebook which only uses Pure Python functions and consumes significantly lower Capacity Units (CUs)). The pattern is how to get new data and merge it into an existing Lakehouse table. This ensures that if the notebook is run again…

In this post I will show how I used GitHub Copilot CLI / Agent mode in VS Code to create a Microsoft Fabric pipeline that checks Lakehouse table health and only optimizes tables that require maintenance. I’ll also show the prompts I used, the issues I ran into, and how Copilot helped me resolve them. Recently Microsoft announced Lakehouse table…

With the new Lakehouse Auto-Binding capability in Notebook Git integration, Fabric can now intelligently preserve and resolve the binding between your notebooks and their attached Lakehouses as you move them across workspaces. This makes true multi-environment development and CI/CD workflows in Fabric significantly smoother and more reliable. I am going to show you how to do this in the blog…

In this blog post I show how it is possible to access data between a Private Link Workspace, where I want to read the data from my Public Workspace. An example of this is where I wanted to use a DirectLake Semantic Model sitting in my Public Workspace where the data is from data in my Private Link Workspace. Get…

Load testing is essential when working with Microsoft Fabric capacity. With limited resources, deploying a Power BI report without testing can lead to performance issues, downtime, and frustrated users. In this series, I’ll show you how to automate load testing using Fabric Notebooks, making the process faster, easier, and repeatable. Inspired by Phil Seamark’s approach, this method eliminates manual complexity…

In the past when there has been an error when loading data into the semantic model, there can be times when clicking on the View errors can either take a very long time to show those errors. Or in some cases it never shows you the error. In this blog post I am going to show you an alternative way…

It is becoming increasingly important to understand how the Power BI reports/Semantic Model that are being used in your organization are performing. When using Fabric Capacities this can potentially be of critical importance, because a single report that is not well designed could cripple or bring down your capacity. By completing Power BI Performance load testing before it goes into…