Welcome to the Power Query Blog!
Read about an introduction to Power Query and how this blog will help our team connect closer with Power Query users.
Read moreBlog | Microsoft Power Query
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 moreStop 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 moreNew 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 morePower 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 moreAdditional 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 moreJoin us at Power BI Summit & SQLBits conferences next week!
The Power Query team will be doing some online sessions in the month of March. Join us and check out what’s new and what’s coming for Power Query.
» Read moreThe Citizen Data Integration Team is Hiring in 2022!
The Citizen Data Integration team is hiring! Read to learn about our team and our open positions.
Read morePower Query Updates in Power BI Desktop December 2021 Release
Learn about new Power Query-related updates in the recent December 2021 release of Power BI Desktop!
» Read moreNew Features in the Power Query Dataverse Connector!
Check out two highlighted features in the Power Query Dataverse connector!
» Read moreIntroducing: the new Power Query Google Sheets connector!
Learn about the new Power Query Google Sheets connector!
» Read more