Hat Full of Data - Page 3 of 12 - Laura GB's notes on how she made data behave

29th May 2024

Use Power Automate to Fetch Secrets from Key Vault

When you store secrets in Azure Key Vault as described in the previous post in this series you need a way to fetch them when you need them

Power Automate/Azure/Power BI

6th April 2024

Create Azure Key Vault to store Tenant ID, Client ID and Secret

Azure Key Vault is a cloud service that provides a secure store for secrets. And in the previous post on creating Power BI Service Principal Profile we added a secret. The Tenant ID, Client ID and Secret values give access to the Service Principal and whatever permission they have. So for that reason we are going to create an Azure Key...

How to/Azure

17th February 2024

Create a Power BI Service Principal Profile

For Power Automate to use the Power BI Rest API it needs a service principal profile. This is created by creating an app registration that has the right permissions. This allows an app, e.g. Power Automate, to establish a trust relationship with the Microsoft identity platform. This is done using Entra Admin Center (previously known as Active Directory) This post...

Power BI/Power Automate

15th February 2024

Power Automate and Power BI Rest API

The Power BI Rest API provides the ability to create a workspace. Power Automate includes an action to make a HTTP call, i.e. a Rest API. So we should be able to get a flow to create a workspace. So that was my goal. Writing the first flow and getting it to work involved so many little steps I had...

Power BI/Power Automate

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.

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

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.

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.

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...

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.

Introduction/Power Automate