execute_dax_query
Execute DAX queries against Power BI/Fabric datasets to inspect business data, measure outputs, and test Row-Level Security by simulating user access.
Instructions
Execute a DAX query against a published Power BI semantic model / Fabric dataset.
Use this tool when the user asks to:
Run, evaluate, or test a DAX query against a live dataset in Power BI or Fabric.
Inspect actual business data, measure outputs, KPI calculations, or table rows.
Verify Row-Level Security (RLS) filters by simulating a specific user principal name.
Args: workspace_id: Fabric / Power BI workspace ID (UUID). dataset_id: Published semantic model / dataset ID (UUID). dax_query: The DAX query expression (e.g. "EVALUATE TOPN(10, 'Sales')" or "EVALUATE ROW("Total", [Total Sales])"). impersonated_user_name: Optional User Principal Name (UPN) to test RLS rules as that user. auth_mode: "interactive" (default, browser login) or "service_principal". tenant_id: Azure AD tenant ID (required for service_principal). client_id: Azure AD client ID (for service_principal). client_secret: Azure AD client secret (for service_principal). fabric_client: Optional injected FabricClient instance (for testing).
Returns: Dict containing query execution results with tabular rows, columns, and execution metadata.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| auth_mode | No | interactive | |
| client_id | No | ||
| dax_query | Yes | ||
| tenant_id | No | ||
| dataset_id | Yes | ||
| workspace_id | Yes | ||
| client_secret | No | ||
| fabric_client | No | ||
| impersonated_user_name | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||