Often, when querying APIs it is required to enter date and time filters in ISO 8601 format . Today I show a quick way to convert DateTime to ISO 8601 string, (…) Read more
Posts Tagged ‘Function’
Retrieve header fields like response status from Web.Contents in Power BI and Power Query
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
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
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
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
Advanced transformations on multiple columns at once in Power BI and Power Query
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