interactive
interactive copied to clipboard
Add support for Power Query M Formula Language
It would be very helpful in the development and testing of Power Query (M) code for Power BI and Excel.
I'd like for the Power Query (M) Formula language to become a supported language by Polyglot notebooks. Ideally the notebook could run bits of M code and display the results.
Code Samples
Create a table by inferring the number of columns from the first row.
Usage
let
Source = #table(
null,
{
{"Betty", 90.3},
{"Carl", 89.5}
}
)
in
Source
Output
#table(
{"Column1", "Column2"},
{
{"Betty", 90.3},
{"Carl", 89.5}
}
)
Polyglot Notebook Result
Column1 | Column2 |
---|---|
Betty | 90.3 |
Carl | 89.5 |
Creating a table then adding a column
Usage
let
Source = #table({}, {})
in
Source
Output
#table({}, {})
Polyglot Notebook Result
Column1 | Column2 |
---|---|
The Power Query SDK Visual Studio Code extension makes it possible to execute PQ(M) code, but it doesn't have the portability and markdown support that notebooks do. Being able to walk people through how you came to a solution would be very helpful.