eval_dax_offline
Evaluate DAX queries on a closed .pbix file without a persistent session: briefly opens Power BI Desktop, runs the query, returns result rows, and closes.
Instructions
Evaluate a DAX query against a CLOSED .pbix and return the result rows (columns + rows). Briefly opens the file in the local Power BI Desktop (a Desktop window appears), runs the query against its engine, then closes Desktop. Accepts a full 'EVALUATE ...' query or a bare table expression (EVALUATE is prepended). Same result shape as run_dax, but no session / no manually-open Desktop.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dax | Yes | DAX query (EVALUATE ...) or a table expression | |
| pbixPath | Yes | path to the closed .pbix | |
| timeoutSec | No | seconds to wait for the model to load before giving up (default 180) |