A Practical Guide to use OneLake Security for OneLake Object, Row, and Column Security
In this blog post, I will show you how to configure OneLake security for a Microsoft Fabric Lakehouse. We will remove the default broad-access role, grant the required Lakehouse access, configure object-, row-, and column-level security, and test the results. The goal is to create a secure-by-default setup in which users can access only the data they need. Prerequisites You…
Creating a Private Link in Microsoft Fabric — No Public Access
In this blog post, I am going to walk through how I created a Private Link in Microsoft Fabric so that access routes over Microsoft’s private backbone network instead of the public internet. NOTE: It is a bit of a longer blog post as there are quite a few things that need to be configured. NOTE II: In the next…
How to set up a SharePoint Folder Shortcut using Workspace Identity in Microsoft Fabric
I really think it is ideal to use a workspace identity in Microsoft Fabric. This is because not only is it secure by default but not having to manage any client secrets. It also means that it is then owned by the business, so there are no issues if a user leaves or a user password expires. In this blog…
How I Built a Full Power BI Semantic Model in Minutes Using Agentic AI and GitHub Copilot
In this second part of my blog series, I will show you how I edited the required files and then created my semantic model by using the Agentic Tools. To be transparent, I did use Claude to assist me with the initial setup steps below. This is quite a long blog post, so maybe make yourself something to drink a…
How to Set Up Agentic Semantic Model Development for Power BI Using GitHub Copilot on Windows
I was inspired and in awe after watching the video that Rui Romano posted in LinkedIn where Rui shared a video on how he used Agentic model development works 202603 AgenticE2E FabCon. It looked like all that I had to do was have the right tools to use, edit a few files and let the LLMs do the rest! In…
Restore Microsoft Items from Backup using Python & Fabric CLI
In my previous blog post I had shown you how to backup your Microsoft Fabric Items: Backing Up Your Microsoft Fabric Workspace: A Notebook-Driven Approach to Disaster Recovery – FourMoo | Microsoft Fabric | Power BI The next natural question is what happens when you want to restore one if the items that were previously backed up. In the steps…
Microsoft Fabric Lakehouse vs Warehouse 1 Billion Rows which will be faster?
My previous blog post got a lot of comments and suggestions which is great. You can view it here for reference: Microsoft Fabric: Why Warehouse Beats Lakehouse by 233% in Speed and 278% in Capacity Savings – FourMoo | Microsoft Fabric | Power BI I learnt a lot and based on the feedback people asked for me to compare the…
Microsoft Fabric: Why Warehouse Beats Lakehouse by 233% in Speed and 278% in Capacity Savings
After my previous blog post on the different semantic model options and at the same time working with a Fabric customer, it got me thinking which is faster and which consumes less capacity when ingesting data into Power BI either via the SQL Endpoint to a Lakehouse or a query from the Warehouse. Below you will find the information which…
How Much of Your Fabric Capacity Is Really Being Eaten by Background Jobs? (The 24-Hour Smoothing Trick Explained)
I was recently working with a customer and one of the questions they had is we are going to be running an ingestion process. We want to know how much Fabric Capacity this will be consuming. The challenge with this question is that in Fabric a background capacity gets smoothed over 24 hours. For example, when looking at the Capacity…
Direct Lake or Import which Semantic Model has the best performance
In this blog post I am going to show you how I completed the automated testing and then the results where I am going to compare Direct Lake, Import and DirectQuery and which one appears to be the best. As always, your testing may very or be different to my tests below. I would highly recommend that you use the…