SQL Query with Native Query in Power Query M

Runs a hand-written SQL query against a database instead of letting Power Query build the query visually.

Database & RefreshIntermediatesqlnative querydatabase

Power Query M code

let
    Source = Sql.Database("YourServer", "YourDatabase", [Query = "SELECT OrderID, OrderDate, Amount FROM Sales.Orders WHERE Amount > 100"])
in
    Source

Notes

Native SQL queries can fold better for complex logic, but Power BI Desktop will warn about native database queries for security review before running them.

Requirements

A SQL Server (or compatible) database connection.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to SQL Query with Native Query.