Today I want to share quick tip on how to automatically detect and change all column types at once in Power Query. Background Very often, when you expand a column (…) Read more
Create a load history or stage in CDS instead of incremental load in Power BI
If you’ve been following my blog for a while, you might have noticed my interest in incremental load workarounds. It took some time before we saw the native functionality for (…) Read more
Power BI “Store datasets in enhanced metadata format” warning
Edit October 2020: This feature is now generally rolled out, so there is no way to go back to the old format any more. From what I’ve heard, the problems (…) Read more
Tips to download files from webpages in Power Query and Power BI
When downloading data from the web, it’s often best to grab the data from APIs that are designed for machine-to-machine communication than from the site that’s actually visible on the (…) Read more
Calculating doubling times with DAX in Power BI
In this article I show methods to calculate the doubling time with DAX in Power BI. Doubling time is an indicator used for exponential growth scenarios. It indicates how much (…) Read more
Trimming text with custom characters in Power BI and Power Query
When cleaning dirty data, you might have used the Trim-function (Text.TrimStart or Text.TrimEnd) to delete leading or trailing whitespace from your strings. However, did you know that you could use (…) Read more