Provides utilities to read data from PowerBI dataset open locally
Project description
Overview:
Project based on pyadomd, thank you SCOUTsoftware.
It aims to connect simply to any locally opened PowerBI dashboard, and export data from it.
Data is provided as a pandas DataFrame.
Usage examples:
Get data from a table in the PowerBI report:
import pbi_local_connector as pbi
df = pbi.getTableFromReport("MyTableName")
You can also get report id and report port using the following:
import pbi_local_connector as pbi
reportId, reportPort = pbi.getReportInfo()
Known limits:
- Only 1 PowerBI dashboard must be opened, otherwise it can causes inconsistencies,
- ADOMD library must be manually installed from ms source.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file pbi_local_connector-0.5.tar.gz.
File metadata
- Download URL: pbi_local_connector-0.5.tar.gz
- Upload date:
- Size: 2.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.0.0 CPython/3.12.2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | df71876126be1cbc232c3bb0f9b2cef41276c21b0fffc3136a61fcf48aa5e667 |
|
| MD5 | a4b64c0fc506a927c6cc4200a72810df |
|
| BLAKE2b-256 | dd2c16bdea2dc3823a0cc8b6d9785698fd0f0ace47693a1a0ed799a3989ee57d |
File details
Details for the file pbi_local_connector-0.5-py3-none-any.whl.
File metadata
- Download URL: pbi_local_connector-0.5-py3-none-any.whl
- Upload date:
- Size: 3.4 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.0.0 CPython/3.12.2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 79a72976ef7b0455e20ce10fbd1862e13e41a5e2a8a1fb1bd49e35aa73b606a4 |
|
| MD5 | f8f08e7510eda6b00700ddcea6686eb2 |
|
| BLAKE2b-256 | de297a21ccd4613beaceefa2ca429c3e0ef3412e7a8bfd777c88f028effc999b |
