pbi_validate_power_query_steps
Validate Power Query M expressions by checking for required step patterns, enabling automated grading of data transformation exercises.
Instructions
Verify that a Power Query (M) expression contains expected step patterns.
Each entry in expected_steps is treated as a substring (or regex if it
starts with re:) that must appear at least once in the M expression.
Useful for grading exercises: e.g. checking that a postal-code column has
been left-padded to 5 chars, or that rows with null customer ids are
filtered out.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| case_sensitive | No | ||
| expected_steps | Yes | ||
| partition_name | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |