Power Query File Upload: Uploaded a file with 3 excel workbooks into Power Query and used the Excel.Workbook to extract required tables. Also uploaded two different tables within an excel workbook.

NOTE: This post was written before Data Explorer was renamed as Power Query. All of the content is still relevant to Power Query. One of the first questions I get asked after showing someone ...

In part 4 of this series (sorry for the long wait since then!) I finished off looking at what you can do with named sets. Now, before I go on to more important topics like Excel cube functions and ...