Seamlessly Moving Fabric Notebooks Across Workspaces with Lakehouse Auto-Binding and Git Integration
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…
Accessing data between Private Link and Public Fabric Workspace using the Private Endpoint
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…
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…
Automating Power BI Load Testing with Fabric Notebooks – Part 1: Capturing Real Queries
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…
How to quickly find rows with errors in Power Query when using Power BI
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…
Why should I complete Power BI Performance Load Testing & initial setup
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…
Updating your Query syntax in Power Query to show the entire query in M
Welcome to 2023, I am looking forward to an amazing year! I have seen this come up a few times in Twitter where there is an option to put in your own TSQL Query or DAX Query and the input box is very small and often you cannot see the entire query as shown below. I will show you how…
Did you know you can get the advanced filtering pane to show more than two items in Power BI?
Recently I found out a way to update the advanced filtering pane to show more than the default of two items. This is what it looks like by default. What I figured out was to then have an extra 4 options to filter on. The reason that this came about is because I was using at integer field which does…
How to resolve error when deploying changes to Power BI Premium Per User for Incremental partitions
I have been doing a lot of work recently using Power BI Premium Per User and recently I got the following error below when trying to update my fact table in Power Query. “An unexpected error occurred (file ‘tmsavepoint.cpp’, line 1503, function ‘TMSavePoint::GetProxyImpl’)” This is what the actual error looks like. This is rather a confusing error and it can…
How to connect to a Power BI Premium Per User using SQL Profiler
I was recently looking on how to use SQL Profiler to connect to my Premium Per User (PPU) dataset so that I could see where the processing of my incremental partitions was. When I first tried to connect using the default options, I got the error “Either the race with the ID of ‘AAA’ does not exist in the server…