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
Posts in Category ‘M’
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
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
Date.Networkdays function for Power Query and Power BI
Today I’m going to share my custom NETWORKDAYS function for Power Query with you that uses the same syntax than its Excel-equivalent. NETWORKDAYS function This function’s first 3 parameters work (…) Read more
Tidy up Power BI models with the Power BI Cleaner tool
Edit: I am retiring support for this tool for now, as you can find an alternative here: Measure Killer | Brunner BI. Please feel free to use this tool as (…) Read more