Skip to content

Hat Full of Data

Laura GB's notes on how she made data behave

  • Home
  • About Laura GB
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.

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

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

Categories Power Automate/DevOps
16th August 2024

Update DevOps without Notifications with Power Automate

When a work item is assigned to you, you are sent a notification. In this post we show how Power Automate can update without notifications

Categories Power Automate/DevOps
14th August 2024

Running a Wiql DevOps query in Power Automate

Wiql is the language used to define the queries in Azure DevOps. Power Automate can use a REST API to execute the wiql.

Categories Power Automate/DevOps
13th August 2024

Using DevOps REST API in Power Automate

DevOps REST API is a well documented API that we can easily use in Power Automate to perform a huge range of actions.

Categories Power Automate/DevOps
29th July 2024

Power Automate Update Fields in Azure DevOps

This post shows you how to find the names for fields and how to update fields in Azure DevOps using Power Automate

Categories Power Automate/DevOps
25th July 2024

Connecting Power Automate to DevOps

This post explores connecting Power Automate to DevOps for item creation and item editing and includes troubleshooting the connection

Categories Power Automate/DevOps
21st June 2024

Power Automate – Create Power BI Workspace

This post will finally create the flow to automatically create the Power BI workspace making use of all the preparation in previous posts.

Categories Power BI/Power Automate
17th June 2024

Allow the use of Power BI Rest APIs

This post walks through doing the changes allow the use of Power BI Rest APIs by the service principal created in post 1

Categories Power BI/Entra

Posts pagination

  • «
  • 1
  • 2
  • 3
  • 4
  • 5
  • …
  • 11
  • 12
  • »

Recent Posts

  • First refresh it broke! #LauraBrokeIt
  • SharePoint Folder into Microsoft Fabric
  • VBA – Using Dictionaries to improve searching
  • Power Query – Handling Null Values Properly
  • Power Query – Fixing Missing Columns Dynamically

Categories

  • AI Builder
  • Azure
  • Charticulator
  • Community
  • Components
  • Dataflow
  • Dataverse
  • DevOps
  • Entra
  • Excel
  • Flow
  • How to
  • Intermediate
  • Introduction
  • M
  • Microsoft Fabric
  • Paginated Reports
  • Power Automate
  • Power BI
  • Power Query
  • PowerApps
  • Project
  • SVG
  • Uncategorized
  • Updates
  • VBA
  • YouTube

Archives

  • May 2025
  • March 2025
  • January 2025
  • October 2024
  • September 2024
  • August 2024
  • July 2024
  • June 2024
  • May 2024
  • April 2024
  • February 2024
  • November 2023
  • August 2023
  • July 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • November 2022
  • September 2022
  • July 2022
  • June 2022
  • January 2022
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • LinkedIn

©2025 Hat Full of Data

Coldbox WordPress theme by mirucon

  • Twitter
  • Linkedin
  • Youtube
Back To Top