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
Support for Native Queries in the Azure Databricks connector
Learn about newly released support for native queries in the Azure Databricks Power Query connector!
» Read moreImplement Native Query support in your Power Query Custom Connectors
We’ve just released support for implementing native query support in your own Power Query custom connectors through the use of the Power Query SDK. This new support allows Power Query connector developers to implement support in their connectors to enter a native query that can run against their data sources through the use of the […]
» Read moreNew Web.Headers M function
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 moreAzure AD-based Single Sign-On for Dremio Cloud and Power BI
Read about our release of Azure AD-based Single Sign-On for Dremio Cloud and Power BI
» Read morePower Query SDK for Visual Studio Code – Public Preview
We are excited to announce the Public Preview release of our new Power Query SDK for Visual Studio Code!
» Read moreNew 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 moreCertified connectors available in Power BI dataflows and datamarts
We are excited to announce the availability of 80+ additional data sources (all certified connectors) to the Power Query Online experience in Power BI dataflows and Datamarts
» Read moreIntroduction 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 moreNew Power Query M Language keyword: catch
An article on the new catch keyword added to the Power Query language for the try catch statement
» Read moreNew 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