Category: Excel

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

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

5th March 2023

Export Data from Power BI Visuals

We have to accept that the business will want to export Power BI data into Excel. This post explores the options.

Categories Excel/Power BI

21st April 2021

Power Query – VBA to Edit a Parameter Value

This post is to document how to use Excel VBA to edit a parameter value without using the a cell reference in Power Query.

Categories Power Query/Excel/VBA