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…
Using Power BI DirectLake in Microsoft Fabric
I am super excited to release this blog post and I cannot wait to start using Microsoft Fabric and all the different components. The goal of my blog post is to look at how I could use Microsoft Fabric from a Power BI developers point of view. Microsoft Fabric is a new all in one platform which includes Power BI….