A collection a useful tools for building queries in the Power Query Formula Language ("M") used by Microsoft Power BI.
Power BI does not (appear) to currently support external dependencies so setup is a little rudimentary.
- Create a new blank query.
- Copy the content of M.pq to this query using the advanced editor.
- Name the query
M.
Functions may then be access from other queries as records on M. For example, Pipe may be invoked as:
M[Pipe]({functionA, functionB, ...})
Do not directly edit M.pq. This is built from the components defined in src/. It is provided, preassembled for convenience only.
To add functions, create new *.pq files within src/ containing the
expression body and any relevant documentation (see the other files for
reference). When compiled, the expression will be bound to the name of the file.
runhaskell build.hs