Excel Unplugged

Tag Archives: Power BI Desktop

Utilizing Power Query Lists 3/3

Dynamically retaining only columns that contain Actual values from a Table This article is part 3 of the Using Power Query lists series. In this series, we will look ...

Filtering a Table to a List of Values in Power Query or Power BI

Knowing how to use Lists in Power Query or Power BI is like a superpower. This Post will show you how to filter a Table to a Dynamic List of Values by using Lists in ...

Get a random subset of data with Power Query

The other day I made a Dashboard with a classic by time and relevant dimensions analysis. The data was pulled from Azure SQL DB, so Power Query was the method I ...

Power BI publisher for Excel (The Times They Are A-Changin)

The title of this post is stolen from the legendary Bob Dylan song, but rightfully so since it’s one of the biggest game changers in the Power BI game (and ...