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…
How to create a Case Insensitive Warehouse in Microsoft Fabric
This is a quick blog post to show you how to use a Microsoft Fabric Notebook to quickly and easily create a Case Insensitive Warehouse. Just a quick note when I talk about a Case Insensitive Warehouse, what that means is that the upper casing and lower casing of column names and text are ignored. By default, Warehouses and Lakehouse’s…
How to read and write to different Lakehouse’s in different App Workspaces when using a Fabric Notebook
With the new Schema’s in a Lakehouse, it now is possible to read from Lakehouse A (In Workspace A) and write to Lakehouse B (In Workspace B). Here are more details about the Schema preview: Lakehouse schemas (Preview) – Microsoft Fabric | Microsoft Learn This opens a whole new world of possibilities. I also really like the fact that I…
Understanding what is consuming your Fabric Storage
This blog post will show you how to understand what is consuming your Fabric Storage. If you want to know how I got this data, please read my previous blog post View all your Storage consumed in Microsoft Fabric – Lakehouse Files, Tables and Warehouses – FourMoo With this Semantic model below, I could also create alerts to notify based…
View all your Storage consumed in Microsoft Fabric – Lakehouse Files, Tables and Warehouses
One of the things I have found when working with my customers in Microsoft Fabric is that there is currently no way to easily view the total storage for the entire tenant. Not only that, but it would also be time consuming and quite a challenge to then find out what is consuming the storage. Could it be large files…
Configuring the Service Principal access Microsoft Fabric OneLake APIs
This blog post explains how to configure access for my Service Principal to interact with the Azure Storage API to use the API to get details for Microsoft Fabric Storage. This is part of a blog post series where I am going to show you how to “View Total Storage consumed in Microsoft Fabric” When I started this blog post…
How to view or track the progress of Notebook while it is running in Microsoft Fabric
How to view or track the progress of Notebook while it is running in Microsoft Fabric I was recently working with a Notebook in Microsoft Fabric that was started via a Data Pipeline. The challenge I had was that I had no idea how far the notebook had gone (as there were quite a lot of cells in this particular…
Using a Service Principal to get all Entra ID Group Members into JSON File using a Python Notebook
Using a Service Principal to get all Entra ID Group Members into JSON File using a Python Notebook Sometimes it is useful to get all Group Members into a JSON file so that this could be used for reporting purposes. Reference Notebook: Get Entra ID Group Members – Power BI In the steps below I will show you how I…