Hat Full of Data

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

DevOps/Power Automate

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.

DevOps/Power Automate

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.

DevOps/Power Automate

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

DevOps/Power Automate

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

DevOps/Power Automate

21st June 2024

Power Automate – Create the 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.

Power Automate/Power BI

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

Entra/Power BI

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

Azure/Power Automate/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...

Azure/How to

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