Power BI Header Auth icon

Power BI Header Auth

Work with the Power BI API using header authentication

Actions36

Dataset → Execute Queries

AI-generated

Summary

Execute a DAX query against a specified Power BI dataset to retrieve data based on the query.

Inputs

  • Authentication Token (required) — Bearer token for authentication without the "Bearer" prefix.
  • Group (Workspace) Name or ID — Power BI workspace ID to scope the dataset. Leave blank to use "My Workspace".
  • Dataset Name or ID (required) — ID of the target dataset to execute the DAX query on.
  • DAX Query (required) — DAX query string to execute against the dataset.
  • Include Nulls — Boolean flag to include null (blank) values in the query result.
  • Impersonated User Name — User principal name to impersonate for the query if the dataset supports row-level security (RLS).

Output shape

A JSON array representing the result set of the executed DAX query, including columns and rows optionally containing nulls if specified.

The operation requires a valid authentication token to call the Power BI API. The 'Group (Workspace)' and 'Dataset' parameters scope the query context. The 'Impersonated User Name' parameter is effective only if RLS is enabled on the dataset. The output contains the raw query results as returned by Power BI without additional transformation.

Discussion