In September 2018 Microsoft introduced the Power Query Online integration for Microsoft Flow. This opens up the possibility of transforming and shaping data within Flow without having to understand OData or SQL. This session will demonstrate different ways of combining data, transforming data, and then exposing the data as a csv, html table or looping through the records to automate a process based on your data within sql server. Finally we will look at the costs, limitations and considerations when using this new feature and the licenses that you require to use these techniques.