SQL Queries. Include clear, structured SQL queries with comments explaining each step. Screenshots of Results. Run the queries in your database environment and capture screenshots of the outputs.

I was super-excited when, a few days ago, the long-awaited integration of Power Query into Microsoft Flow was announced.I was then gutted when work commitments meant I couldn’t blog about it right ...

For example: something I am asked about a lot is whether it is possible to use Power Query to automate the creation of CSV files. You can’t do this in a supported way in Power Query in Excel or Power ...