This content applies to: Power Query online Power Query desktop You may have noticed a new M function was added to Power Query recently: Web.Headers. This function allows you to make HEAD requests to web services – the existing Web.Contents function, which it resembles closely, only allows you to make GET and POST requests. You […]
» Read moreThis content applies to: Power Query online We’re pleased to announce that yet another new transformation has been added to Power Query Online: you can now add columns containing ranks to a table. To see how to use it, consider the following table containing sales and profit values for various products: Let’s say you want […]
» Read moreThis content applies to: Power Query online There’s a new operation available for the Group By transformation in Power Query Online: percentiles. To see how it works, let’s see a simple example. Consider the following Excel table containing information about invoices from different countries: If you connect to this table from a Power BI or […]
» Read moreThis content applies to: Power Query onlinePower BI Desktop Query folding is generally a good thing in Power Query: pushing transformations back to the data source means they almost always perform better. That’s not always the case though and sometimes you need to stop query folding taking place to improve performance. In the past there […]
» Read more