I really like the M Language and Power Query (PQ) makes it really easy and convenient to build data mashups. You can even use it as a SQL query builder by viewing the Native Query code and then copying that.
The main issue I'm facing is how to distribute the library of PQ/M functions I've developed?
Currently I have a central library workbook and then have to copy code from there. Problem is that updates and bugfixes don't flow downstream.
I really hope Microsoft creates a solution for this. Would love to hear about some approaches for handling this in the meantime.