← All postsTopic
Power Query
4 posts on Power Query: benchmarks, internals and workarounds for the Microsoft data stack.
- 04Why Power BI Says a Value Is a Duplicate When It’s Not
Power Query is case sensitive, the model is not, and that mismatch quietly breaks relationship keys. Why it happens, and three ways to fix it.
- 03Make Your Power Query Dynamic with Parameters
Discover how to make your Power Query dynamic with parameters. Learn practical ways to use parameters in Power BI, enhancing flexibility and control.
- 02Ultimate intro to Power Query M Language
What M actually is, how Power Query writes it for you, and how to start editing it yourself. A beginner introduction built on working examples.
- 01Combine Files Quickly in Power Query
Power Query's built-in file combiner generates a folder of helper queries. Two simpler ways to combine files, in roughly one line of M.
4 postsAll posts →