Fabric – How to rename a column name when using a Python Notebook
I thought it would be good to help others in terms of my learning journey when working with partner notebooks and Microsoft fabric. In today’s blog post, I am going to show you how to rename a column. In my experience this came up because I had a column name which had a forward slash “/” in it which caused…
How to calculate Microsoft Fabric costs
I was going to update my existing blog post with regards to the fabric costs. I was then fortunate to be contacted by David Brown from the Microsoft Fabric team who gave me additional details in terms of how to correctly calculate the fabric costs. What is a Capacity Unit or CU? You can think of a CU as CPU…
Microsoft Fabric – Comparing Dataflow Gen2 vs Notebook on Costs and usability
In this blog post I am going to compare Dataflow Gen2 vs Notebook in terms of how much it costs for the workload. I will also compare usability as currently the dataflow gen2 has got a lot of built in features which makes it easier to use. The goal of this blog post is to understand which in my opinion…
How to grant individual users access to create Fabric items/workloads
I was recently working with a customer where I was showing them the awesome new features of Microsoft fabric. I then created a workspace and attempted to grant the individual users access to the workspace to create fabric items or workloads. When the users went into the app workspace with the fabric settings, enabled, the users could not create any…
An easy way to transform/clean your data using a Notebook in Microsoft Fabric
In this blog post I am going to show you an easy way to clean your data (which is often fixing data issues or mis-spelt data) using the new feature Launch Data Wranger using DataFrames I had previously blogged about using Pandas data frames but this required extra steps and details, if you are interested in that blog post you…
Power BI Report for Microsoft Fabric Support Page
This will be one of my shorter blog posts What I wanted to show you is that I have created a Power BI report which shows the Microsoft Fabric Support page details. I created one for Power BI which I receive daily, and it is great to get the subscription so that I am aware of any potential issues or…
How to create and use keys (A work around for Primary Keys) in Fabric data warehouses
When I started looking into using the data warehouses feature in Fabric, I did see that there were limitations on Primary Key columns. Below is my blog post on how I still use keys in my data warehouse, instead of using GUID’s which to me are long and hard to use. In my example I am going to create a…
Part 4 – Creating a Power BI dataset and report using DirectLake
In the final part of my series, I am going to be creating the Power BI DirectLake dataset and report from my tables that I had previously loaded into the lakehouse. In this series I am going to show you all the steps I did to have the successful outcome I had with my client where I created the dataset…
Part 3 – Using Microsoft Fabric Dataflow Gen2 to store the data in the Lakehouse
Following on in my series, in this blog post I am going to use the dataflow Gen2 in Microsoft Fabric to load the data into a lake house table. By doing this, it will allow me to store the data in a delta lake table. In this series I am going to show you all the steps I did to…
Did you know that there is an easy way to shape your data in Fabric Notebooks using Data Wrangler?
I was going through my twitter feed and I came across this tweet where they spoke about the Data Wrangler Calling all #Python users! Have you tried Data Wrangler in #MicrosoftFabric? I thought I would give this a try and that was the idea for my blog post. I honestly had no idea that firstly was this possible, but second…