A typical task when cleaning data is to extract substrings from string that follow a certain pattern. In this post I’m going to describe a method that uses the List.Accumulate (…) Read more
Posts in Category ‘Power BI’
Performance tip to speed up slow pivot operations in Power Query and Power BI
Pivot operations in are a very handy feature in Power Query but they can slow down refresh performance. So with some bittersweet pleasure I can tell that I found a (…) Read more
How not to miss the last page when paging with Power BI and Power Query
When you use an API with a paging mechanism (like the example from this blogpost), you’ll might work with a field that contains the address for the next page. You (…) Read more
Automatically detect and change the types of all columns at once in Power Query
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