add_query_parameter
Add a query parameter binding to a dataset, enabling report parameters to be wired into DAX or SQL/MDX queries.
Instructions
Add a binding to a dataset's query. Use to wire report parameters into DAX (e.g. =Parameters!DateFrom.Value).
PBIDATASET parameter naming rule: in DAX/, write @MyParam (with @). In , write MyParam (no @). SQL/MDX use @ in both places. This tool detects the dataset's provider and AUTO-STRIPS a leading @ from name for PBIDATASET datasets, returning {normalised: true, warning: ...}. Pass force_at_prefix=true to override (rare; needed for some RSCustomDaxFilter patterns).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| path | Yes | ||
| dataset_name | Yes | ||
| force_at_prefix | No | ||
| value_expression | Yes |