download_pbi_xmla 0.2.7.5

A package to fetch and save Power BI tables via XMLA endpoint

Power BI XMLA Endpoint Download to Parquet

This package allows you to fetch and save Power BI tables in Parquet format via the XMLA endpoint.

System Requirements

This package requires a Windows environment with .NET assemblies, as it relies on pythonnet to interact with .NET libraries. Latest version

Python Version Requirement

This package requires Python version >=3.9,<3.13.

Installation

Using Poetry

To install the package using Poetry, run:

poetry add download_pbi_xmla

Using pip

To install the package using pip, run:

pip install download_pbi_xmla

Usage

After installing the package, you can use the fetch_tables command to download and save Power BI tables in Parquet format. Below are the details on how to use the command.

Command Syntax

fetch_tables --server SERVER_URL --db_name DATABASE_NAME --username USERNAME --password PASSWORD --tables Table1 Table2

Parameters

--server: The XMLA endpoint URL for your Power BI service. --db_name: The name of the database you want to connect to. --username: Your username for the Power BI service. --password: Your password for the Power BI service. --tables: The list of tables you want to fetch. You can specify multiple tables separated by spaces.

Example Usage

fetch_tables --server "powerbi://api.powerbi.com/v1.0/myorg/YourWorkspace" --db_name "YourDatabaseName" --username "YourUsername" --password "YourPassword" --tables "Table1" "Table2"

Authentication

The package uses MSAL (Microsoft Authentication Library) to obtain an access token for authentication. The script is designed to work with or without Multi-Factor Authentication (MFA).

Silent Authentication: The script first attempts to acquire a token silently. Device Code Flow: If silent authentication fails, it falls back to the device code flow, which supports MFA.