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

13th January 2025

Power Query – Handling Null Values Properly

This post is about handling null values in Power Query calculations. If you do a calculation in Power Query that involves a null value the answer returned is null.

Power Query

8th January 2025

Power Query – Fixing Missing Columns Dynamically

One of the challenges of making sure your query works in Power Query is data sources that have a changing schema. Some APIs miss out fields if the data is null and sometimes we need one report able to handle data files that are almost the same but not quite. In this post we will look at fixing 2 scenarios, a single missing column and multiple columns missing.

Power Query/M

6th January 2025

Power Query – Creating New Parameters

Good practice is to use parameters for these values so your query is reusable etc. And its always our intention to go and create the new parameter later.

Power Query/Excel/Power BI

6th October 2024

Trigger Microsoft Fabric Data Pipeline using Power Automate

Microsoft Fabric Data Pipelines can be scheduled to happen at regular times. What happens when you want trigger a Microsoft Fabric data pipeline to run as a reaction to an event? For example someone pressing a button in an app. For this we can use Power Automate to start a pipeline using a http request.

Microsoft Fabric/Power Automate

3rd October 2024

Power Automate – Save a File to OneLake Lakehouse

Currently there is no Microsoft Fabric connector in Power Automate. When we want Power Automate to save a file to OneLake Lakehouse, we need to use a workaround. This post walks through the demo I did for the Microsoft Fabric European Conference 2024.

Microsoft Fabric/Power Automate

23rd September 2024

Inherited Value in a Parent Child Pattern

There are times it is useful to calculate an inherited value from parent item to child. The target date of a feature to be passed down to the child user story and then onto the child tasks.

Power BI/DevOps

2nd September 2024

DevOps Parent Child Hierarchy in Power BI

Azure DevOps is built around the pattern than items have child items and so a backlog view will show the items in a hierarchy. When the work items some into Power BI that is not shown. So this gives me the chance to use one of my favourite resources, DAX Patterns and their Parent-Child pattern.

Power BI/DevOps

27th August 2024

Get DevOps Data into Power BI

Azure DevOps is full of data that management want to to report on. Adding a Power BI report is an obvious way to do this. This post is my take on how I would build the reports.

Power BI/DevOps

20th August 2024

Editing Azure DevOps items in Excel

One of the easiest ways to edit a project in Azure DevOps is to connect Excel to the project. This post walks you through connecting to a project and updating the DevOps items in Excel.

DevOps/Excel

19th August 2024

DevOps updates on behalf of another with Power Automate

I had a need to use automation to do DevOps updates on behalf of another person so when the DevOps adoption metrics were done we the stats were slightly more accurate.

Power Automate/DevOps