Downloads n/athis week

GitHub stars 1

Extension repository on GitHub

Extension descriptor (YAML)

DuckDB extension for querying Power BI Semantic Models with DAX.

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/XMLA. Authenticate with Azure CLI first (az login), then use SET pbi_scanner_auth_mode='azure_cli' for session-default auth and replace the workspace and semantic model placeholders with values you can access.

Added Functions

This extension does not add any functions.

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings

This extension does not add any settings.