Search Results for: power query

Connect to Spotify using Power Query

Spotify has a massive music database, and in this article we're going to look at how to connect to Spotify using Power Query. Step 1: Get API credentials from Spotify The first thing you'll need to do is to collect

Read More »

Power Query Recipes

Power Query Recipes Digital Edition Available through Skillwave Training Printed Edition Not available This set of ready-to-use Power Query Recipes will lead you step-by-step through a variety of data transformations and techniques. These recipe cards were created based on many

Read More »

Label Duplicates with Power Query

Recently, a reader commented on a blog post that I wrote back in 2015.  Their question essentially boiled down to working out how to label duplicates with Power Query.  As an additional twist though, they also wanted to ensure that

Read More »

Excel Power Query

Microsoft Excel - Power Query COURSE DESCRIPTION So you’ve impressed your coworkers with your encyclopedic memory of formulae, become a Pivot pro, and started working IF statements into regular conversation. Now what? We say, Power Query. In a world where

Read More »

Creating Power Query Based Calendars

We’re super excited to announce that we have given the Monkey Tools calendar creator feature an upgrade.  In fact, it is so much of a power up, that this feature has graduated into its own full grown monkey!  We call

Read More »

Unfill in Power Query

Recently I received a question on how to Unfill in Power Query.  In other words, we want the opposite of the Fill feature, which fills data into blank cells (cells that contain a null value.)  If we see repeating values,

Read More »