Using a Python Notebook using Semantic Link Labs to write a DAX Query output to a Lakehouse Table
In this blog post I am going to explain how to use a Python Notebook using the Semantic Link module, to run a DAX query and write the output to a Lakehouse table. I will show you how to install a Python library and then use it within my python notebook. If you are interested in more details on why…
How to use SQL Code to write to Delta Tables in a Python Notebook
In this blog post I am going to explain how to use SQL Code to write to Delta Tables in a Microsoft Fabric Lakehouse. If you are interested in more details on why I am using a Python Notebook please read this blog post: What are the advantages of using Python Notebook vs a Spark Notebook in Microsoft Fabric –…
How to use SQL Code to read from Delta Tables in a Python Notebook
I come from a TSQL background, so using SQL makes it easy for me to work with data. There are multiple ways to use SQL in a PySpark notebook, and when I started using a Python notebook it was not so straightforward. In this blog post I will show you how I use SQL Code. As mentioned previously I am…
What are the advantages of using Python Notebook vs a Spark Notebook in Microsoft Fabric
I would like to start off because I am by no means a Python expert. I have been learning Python for about 2 years 😊 This is the first blog post in a series of blog posts where I dive into how to use Python notebooks instead of Spark notebooks. For example, I will show you how to run a…
How to get all your Fabric Items using Python Only Notebook
This blog below explains how to use a Python only notebook to get all the Fabric items using the Fabric REST API. NOTE: At the time of this blog post Feb 2025, Dataflow Gen2 is not included in the Fabric items, I am sure it will be there in the future. NOTE II: This only gets the Fabric Items, which…
Getting Notified when a Microsoft Fabric Notebook fails
What I have found is that when I created a pipeline in Microsoft Fabric that uses a notebook, when there is an error with the notebook, I do not get an alert that the notebook has failed. This has happened to me in the past and I have found this pattern below to work consistently to notify me of errors….
Using a Microsoft Fabric Notebook to get all Power BI Licenses
In this blog post I am going to show you how to get all the Power BI licenses in your tenant. This can be very useful to understand how many licenses you have, what type of licenses are being paid for, and potentially how you can save by removing licenses due to inactive use or if the licenses are no…
Creating a Microsoft Fabric Warehouse using a Service Principal
There is a new blog post from the Microsoft Fabric team talking about the support for using a Service Principal with a Warehouse. Reference: Service principal support for Fabric Data Warehouse | Microsoft Fabric Blog | Microsoft Fabric In this blog post I am going to show you how to create a Microsoft Fabric Warehouse, where the owner will be…
Copying SQL Server On-Premises data in Microsoft Fabric, which one consumes the least amount of Capacity Units
In this blog post I am going to determine which item workload uses the least amount of Capacity Units when copying the same data from an On-Premises SQL Server. The item workloads that I can use to copy data are Dataflow Gen1, Dataflow Gen2 and Pipelines. Setup for Dataflow Gen1 Below is how I configured my Dataflow Gen1 to get…
Microsoft Teams can answer questions using Microsoft Fabric AI Skills and Copilot Studio
I personally think that AI Skills fills the gap perfectly when looking to answer those Ad-hoc questions which cannot be catered for in the Power BI Semantic Models. For example, while it is possible to calculate returning customers in Power BI, the measure is complex and use a lot of resources to get the result. When comparing this to running…