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. Categories Power Query/Excel/Power BI Comments: 0
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. Categories 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. Categories 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. Categories Power BI/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
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 Power Automate/Azure/Power BI
17th February 2024 Create a Power BI Service Principal Profile For Power Automate to use the Power BI Rest API it needs a service principal 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 BI/Power Automate
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 BI/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. Categories Power Automate/Power BI