Loading Files With Varying Schema in Power BI using Power Query

Unpivoting in PowerQuery is easy, but what if you don’t know how many columns you have to unpivot?

July 4, 2023 · 3 min · 429 words
A robot hand holding a red flower

Designing Power BI Reports - Colour Themes with Stable Diffusion

UX design for the non-designer. Me. Using AI.

June 26, 2023 · 5 min · 945 words
A Gateway. But not just any Gateway. A Data Gateway.

Using a Service Principal to Refresh a Dataset via a Data Gateway

Fun with Powershell: Refreshing a Dataset via a Data Gateway using a Service Principal.

December 7, 2022 · 7 min · 1448 words
Cappuccino

Adding Images from a Datalake to a Paginated Report using Databricks

Keeping those sensitive images off the web

November 30, 2022 · 4 min · 775 words
Rows of small candles in red glass holders

Stacked Column Chart in Vega-lite

Stack that chart, and label that data

November 24, 2022 · 4 min · 651 words