It is a scripting language which looks like an odd mix of VBScript and PowerShell and “R”. M is a new language that takes on the ET from ETL (Extract Transform and Load).So it came time to take Power Query and M by the scruff and learn it.įirst let’s put these new “Power” technologies in their relative places:

That is until this latest version of Office where you can’t really avoid it. The set of “Power” components (Power Query, Power Pivot and Power BI) all sound a bit like the marketing guys won the naming battle again and don’t really help explain the technology nor where they fit so I avoided it for a long time. Power Query and the language M have been quietly making their way into the Microsoft Business Intelligence stack and in particular Excel for some time. So its a good time to demonstrate some of them and show where BI and Application Development meet. There are some new and powerful Business Intelligence options available to all of us, from scalable cloud platforms to the Excel on the desktop.

How to get power query in excel 2013