A year ago I wrote a post on loading the M code for a Power Query query from a text file using the Expression.Evaluate() function, but I admit that at the time I didn’t understand how it worked ...

🤔 Why Use Excel Power Query Editor? Let’s be honest: Excel’s built-in Power Query editor is... not great. It’s slow, clunky, Windows-only, and the Advanced Editor is barely an editor at all. We got ...

I’ve just learned some really interesting new Power Query/M optimisation tricks! I’m going to write them up here as a series of worked examples rather than generalised patterns because I’m still ...

Data transformation is a critical step in building data models and business intelligence reports. Power Query is an invaluable tool for anyone who wants to master data transformation, and this book ...