Downloads 5.4kthis week

GitHub stars 16

Extension descriptor (YAML)

DuckDB extension for querying Power BI Semantic Models with DAX.

Compatibility Matrix

This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

Installing and Loading

INSTALL pbi_scanner FROM community;
LOAD pbi_scanner;

Example

INSTALL pbi_scanner FROM community;
LOAD pbi_scanner;
SET pbi_scanner_auth_mode = 'azure_cli';

SELECT *
FROM dax_query(
    'Data Source=powerbi://api.powerbi.com/v1.0/myorg/Example%20Workspace;Initial Catalog=example_semantic_model;',
    'EVALUATE ROW("probe_ok", 1)'
);

About pbi_scanner

Query Power BI Semantic Models from DuckDB using DAX via XMLA endpoint.

• The dax_query function executes DAX and returns results as DuckDB tables.
• pbi_tables, pbi_columns, pbi_measures, and pbi_relationships expose INFO.VIEW metadata results for model exploration.

The easiest way to get started is Azure CLI auth (az login) with SET pbi_scanner_auth_mode = 'azure_cli', but Azure CLI is not required.

connection_string and dax_text are positional. Named options use :=: auth_mode, access_token, secret_name, tenant_id, client_id, client_secret, effective_user_name, timeout_ms, schema_probe_rows, normalize_dax_column_names.

You may also use the DuckDB azure extension to create an Azure secret. More details and examples are in the pbi_scanner repository.

Added Functions

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings