Many Power Query function not only return their values as advertised in their function documentation, but on top of that a metadata record. This record is like tag that holds (…) Read more
Posts in Category ‘M’
Transform a query into a function in Power Query and Power BI
In my previous blogpost I’ve described a method how to extract a substring that follows a certain pattern from a string. In this post I show how to transform a (…) Read more
Extract pattern string and numbers from text using List.Accumulate in Power Query
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
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
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