13th November 2023 Microsoft Fabric – Notebook and Data Wrangler Using a combination of Notebook and Data Wrangler means we can transform data and write to table writing very little code by hand. Categories Microsoft Fabric
10th November 2023 Microsoft Fabric – Create tables with Dataflows As part of Microsoft Fabric, we have new Gen2 Dataflows and they have a new ability. A Gen2 Dataflow entity can have a destination, eg a table Categories Microsoft Fabric
9th November 2023 Microsoft Fabric – Create table from CSV file In a previous post we uploaded a csv file into the Lakehouse. In this post we take the next step to create table from csv file loaded. Categories Microsoft Fabric
7th November 2023 Microsoft Fabric – Upload a CSV file and folder The simplest way to add data to a Lakehouse is upload a csv file or a folder of csv files. These can then be ingested easily into a table. Categories Microsoft Fabric
2nd November 2023 Microsoft Fabric – Create a Lakehouse Lakehouses are one of the main building blocks in Microsoft Fabric. A lakehouse allows you to store structured and unstructured data in a single location. In this post we are going to create an empty one. Future posts will populate it. YouTube Version Empty Workspace with a Fabric Capacity We start in an empty workspace that has a capacity assigned... Categories Microsoft Fabric
9th August 2023 Power Automate – Write Me a Flow Power Automate create includes a feature called Describe it to design it which will write me a flow if I can describe it. Categories Introduction/Power Automate
7th August 2023 Power Automate Button in a Power BI Report You can add an action to a Power BI report by adding a Power Automate button. The button will trigger a flow to run and perform actions. Categories Power Automate/Power BI
11th July 2023 Power Automate – Get data from a Power BI dataset Power BI datasets contain a rich useful data resource that would be really useful in a Power Automate flow. In this post we will walk through how to get data from a Power BI dataset and then email that data. This is just one example of how you could use data fetched from a Power BI dataset behind a report.... Categories Power Automate/Flow/Power BI
7th July 2023 Power BI – Creating a Custom Smart Narrative Power BI desktop includes the Smart Narrative visual. This will summarise a page or visual in your report for you. Often though the summary it produces is not the summary you would have written. This post will show you how to write your own custom smart narrative that updates and filters exactly the same as the standard smart narrative. YouTube... Categories Power BI
22nd May 2023 Power Platform Solution and Power BI – Part 3 In Part 1 we added Power BI to the Power Platform solution and then in Part 2 we added a dashboard. This is post we will embed the report into a form and filter the report to match the context of the form. For this we will use the Accounts form and filter the expenses report to only show the... Categories Dataverse/Power BI