execute_query
Execute a read-only MDX or DAX query against an SSAS database. Returns results as a JSON table with row count and truncation indicator.
Instructions
Execute a read-only MDX or DAX query against the SSAS database.
Use MDX (SELECT ... FROM [Cube]) for multidimensional cubes and DAX (EVALUATE ...) for tabular models. Results are returned as a JSON table {columns, rows, row_count, truncated}. Rows are capped (default 10000, or SSAS_ROW_LIMIT) and 'truncated' is true when the cap was hit. Only SELECT/WITH (MDX) and EVALUATE/DEFINE (DAX) statements are accepted - anything else is rejected.
Args: query: The MDX or DAX query text. max_rows: Optional per-call row cap (0 = use the server default).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| max_rows | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |