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