2023-2024 Archives - Hat Full of Data

17th February 2024

Create a Power BI Service Principle Profile

For Power Automate to use the Power BI Rest API it needs a service principle 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 Automate/Power BI

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 Automate/Power BI

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

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.

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

Flow/Power Automate/Power BI

Tag: 2023-2024

Create a Power BI Service Principle Profile

Power Automate and Power BI Rest API

Microsoft Fabric – Notebook and Data Wrangler

Microsoft Fabric – Create tables with Dataflows

Microsoft Fabric – Create table from CSV file

Microsoft Fabric – Upload a file and folder

Microsoft Fabric – Create a Lakehouse

Power Automate – Write me a flow

Power Automate button in a Power BI Report

Power Automate – Get data from a Power BI dataset