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…
Fabulous Fabcon Vienna 2025
In this blog post I will be covering the Fabcon Vienna updates. Apologies for the misspelling of the word “Announcements” I had recorded the video and was too lazy to re-record! Below are the slides that I presented in my video along with the links, which could be useful if you want more information. CI/CD 100% Support Fabric Command…
Power BI using TMDL with GitHub Copilot Chat to automate changes for the Dynamic Format String
In the video below I will show you how I used GitHub Copilot Chat to make changes to the Power BI TMDL to find and make changes to the Dynamic Format String. As mentioned in the video this video had almost no planning as I wanted to show you what it is like if you were working with me and…
Comparing Fabric Capacity Consumption – Notebook vs Warehouse SQL
I saw that there was an update where it is now possible to use the Microsoft Fabric Warehouse to copy data directly from OneLake into the Warehouse. This got me thinking, which would consume more capacity to get the data into the Warehouse table. As well as which one would be faster. To do this I am going to be…
How to use the Tabular Object Model using Semantic Link Labs in a Microsoft Fabric Notebook
In this blog post I am going to show you how to use the powerful Semantic Link Labs library for Tabular Object Model (TOM) for semantic model manipulation. The goal of this blog post is to give you an understanding of how to connect using TOM, then based on the documentation use one of the functions. Don’t get me wrong…
Download any Power BI Report from the Power BI Service
I am sure we have all had it where there is Power BI report in the service which has been working for a long time. Then there is a requirement to make a change, and NO ONE can find the original PBIX. There now is an easy way to download the Power BI Report or the Power BI Semantic model…
Running a Power BI Performance load test using Visual Studio Code
This is the final part of my blog series for Power BI Performance testing, where I will finally run the Power BI Performance Load testing using Visual Studio Code. In this blog post I will show you how I set up the test, run the test and view the outputs from the performance testing. Previous Blog posts: Why should I…
Updating the PBIReport.JSON file with the Power BI Performance load testing Values
In the 3rd part of my blog series on Power BI Performance testing, we are now going to take all the values we complete in the previous blog post and update the PBIReport.JSON file. The reason I did this in a separate blog post is because working with JSON files can be tricky and adding to that putting in GUIDS…
How to get the details for Power BI Performance load testing
When completing the Power BI performance load testing, you will need to get details from your Power BI report and App Workspace, which will later be used in the PBIReport.JSON file. In this blog post I will show you how to find those details, so that when it comes time to add it to the PBIReport.JSON file, it will be…
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…