Skip to main

Making Power Automate even more powerful

Power Query lets you reshape, transform and clean data from SQL Server or Azure SQL Databases so you can use it in your automations. You guessed it, saving time and money.

Making Power Automate even more powerful

Power Query lets you reshape, transform and clean data from SQL Server or Azure SQL Databases so you can use it in your automations. You guessed it, saving time and money.

Use Power Query within the Power Automate Designer

Use Power Query within the Power Automate Designer

Apply any Power Query transformation to your SQL data with just a few clicks—right from within the Power Automate Designer. Quickly get the data into the shape you need for all your automations.

Combining data the easy way

Now you can bring data from one or several tables in your database together, then transform and combine them into a single table. Just think of the steps you’re cutting out right there.

Zero code

As with most of our Power Query experiences within your favorite Microsoft products, using it requires no SQL coding skills at all. Let the Power Query Editor do all your transformations for you!

Everything else you want to know

It’s easy to become a Power Query expert—these links will lead the way!

Get started

Sign in with your Power Automate account and create a new flow that connects to SQL Server or Azure SQL Database using the “Transform Data using Power Query” action.