In a previous post, I introduced PowerQuery and demonstrated how to perform various SQL-like operations. This article gives a tour of PowerQuery’s M language that underlies each query. let and in If you select a query and click on the “Advanced Editor” button in the Home tab, you’ll see something like this: This is the […]
Posts Tagged ‘PowerQuery’
Data exploration with PowerQuery
Microsoft’s PowerQuery is a neat tool that allows one to perform SQL-like operations on Excel tables. When investigating a database, I actually prefer using PowerQuery over raw SQL for a couple reasons: PowerQuery displays result sets that are much easier to look at than the a typical SQL plaintext result set. It’s easy to immediately […]