You can apply simple transformations to multiple columns at once in Power Query using the UI only. In this article I show how you can apply advanced transformations on multiple (…) Read more
Posts in Category ‘M’
Dynamically create types from text with Type.FromText in Power Query and Power BI
In this article I’ll show you how to create types from text in Power Query, enabling you to dynamically change types via functions for example. It’ll come out as a (…) Read more
Performance tip for aggregations after joins in Power Query and Power BI
This article was edited on 2nd Nov 2019. JoinKind.Local has been removed to avoid problems with merges on tables with primary keys: In this article you’ll learn how to speed (…) Read more
Parent-Child Hierarchies with multiple parents in Power BI with Power Query
I’ve written about a method to dynamically flatten parent-child-hierarchies also with multiple parents some while ago here. I’ve actually used this approach for Bill-of-materials cases and refined that approach in (…) Read more
Power BI administration made easy with Power BI REST API custom connector
Today I read the (as always) great article by Matthew Roche “Governing Power BI just got a little easier” and couldn’t find a description on how to get to this (…) Read more
Compare Power BI files with Power BI Comparer tool
Have you ever wanted to compare a version of a Power BI file with a previous one? … In the unlikely case that you haven’t yet, just wait until the (…) Read more