interactive icon indicating copy to clipboard operation
interactive copied to clipboard

Add support for Power Query M Formula Language

Open Trace-Elements0 opened this issue 1 year ago • 0 comments

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.

Trace-Elements0 avatar Oct 12 '23 13:10 Trace-Elements0