An ever-popular tool for data analysts, Power Query first made an appearance in Excel and quickly became the engine behind PowerBI. More recently it has appeared in Microsoft Flow as an extension the SQL connector and a tool for CDS. Providing the ability to transform data on the fly, understanding Power Query and the Language M is now an important skill for the keen citizen developer.

In this session we will look at how to transform data ready for your PowerApp or Flow and how to get Power Query to work it’s magic without having to write complex queries in M. For those that do want to push the boundaries further, we’ll look at the options for diving into the M code itself for more powerful options.