Composable queries for Microsoft Power BI.
d4c01388 — Kim Burgess 6 years ago
Add Cartesian product
a42ebd79 — Kim Burgess 6 years ago
Ensure builds are deterministic
93ec4005 — Kim Burgess 6 years ago
Fix incorrect type signature.


browse  log 



You can also use your local clone with git send-email.


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.

  1. Create a new blank query.
  2. Copy the content of M.pq to this query using the advanced editor.
  3. 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

M Language specification

Type system

Internal function references