Skip to main

Blog | Microsoft Power Query

New Rank Column transform in Power Query Online

This 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 more

Introduction to practical Query folding

This content applies to: Power Query Online One of the most powerful capabilities of Power Query and the M Language is Query Folding (also referred to as query delegation, and predicate push-down). Query Folding allows the Power Query Mashup Engine to push the transformations expressed in an M (mashup) query to the data source, in […]

» Read more

New Percentiles Transformation in Power Query

This 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 more

Stop query folding with Table.StopFolding

This 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

New features for the VNet gateway

This content applies to: Power Query Online Power BI datasets We are excited to announce three new features for the VNet data Gateway! New capability to create VNet data gateway clusters. You can use a cluster of virtual network data gateways to load balance the queries executing on the cluster and to avoid a single […]

» Read more

Power Query updates in Excel for Mac

This content applies to: Excel for Mac The Excel team has been working hard on enabling more Power Query functionality inside of Excel for Mac. This article showcases a brief summary of the latest updates to the Power Query experience found in Excel for Mac. This new functionality is now generally available in Excel for […]

» Read more

Additional gateway security roles for Power BI

This content applies to: Power BI Service We are excited to announce additional gateway security roles for Power BI! These additional security roles allow for more granularity in assigning roles for the gateway. The new change is that non-admins of the gateway can be allowed to create connections (data sources) on the gateway. This way, […]

» Read more