evaluate_m
Execute any M expression and retrieve structured results: tables include column names/types, errors return reason and message. Optionally profile columns, count rows, or reference workbook queries by source.
Instructions
Run any M expression and get the result as data. Tables come back with column names, types and the first rows
rows (cell errors shown as #ERROR); lists, records, scalars and functions (with signature) are described too; an M error
comes back as reason + message. With source, the expression can reference that source's queries by name
(e.g. Table.RowCount(Sales)), including unsaved edits of an open workbook. count_rows and profile (Table.Profile:
min/max/nulls/distinct per column) scan the whole result, so they can be slow. ignore_privacy_levels=true disables the
privacy firewall for this throwaway evaluation only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | ||
| source | No | ||
| profile | No | ||
| count_rows | No | ||
| expression | Yes | ||
| timeout_seconds | No | ||
| ignore_privacy_levels | No |