Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Sheets Ahead Part 1

6 April 2022

Welcome to our Power Query blog. This week, I look at uploading data from multiple sheets.


Power Query: Hidden Talents

30 March 2022

Welcome to our Power Query blog. This week, I look at how to find data in hidden sheets.


Power Query: Returning to the Folder

23 March 2022

Welcome to our Power Query blog. This week, I revisit extracting from a folder, as the process has improved since I first blogged about it!


Power Query: Google it

16 March 2022

Welcome to our Power Query blog. This week I look at the Google Sheets connector, available in the Power BI Desktop platform.


Power Query: Random Enough

9 March 2022

Welcome to our Power Query blog. This week I look at generating random data in a list.


Power Query: Too Random

2 March 2022

Welcome to our Power Query blog. This week, I look at another way of generating random data.


Power Query: Totally Random

23 February 2022

Welcome to our Power Query blog. This week, I look at one way of generating random data.


Power Query: Riveting Results Part 10

16 February 2022

Welcome to our Power Query blog. This week, I show how the FilePath Parameter allows me to change the workbook I extract data from.


Power Query: Riveting Results Part 9

9 February 2022

Welcome to our Power Query blog. This week, I create parameters from another Excel file.


Power Query: Riveting Results Part 8

2 February 2022

Welcome to our Power Query blog. This week, I create a parameter to define the location of another Excel source file.


Newsletter