Skip to main content

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pbi_local_connector-0.0.35.tar.gz (3.0 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

pbi_local_connector-0.0.35-py3-none-any.whl (3.5 kB view details)

Uploaded Python 3

File details

Details for the file pbi_local_connector-0.0.35.tar.gz.

File metadata

  • Download URL: pbi_local_connector-0.0.35.tar.gz
  • Upload date:
  • Size: 3.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.0.0 CPython/3.12.2

File hashes

Hashes for pbi_local_connector-0.0.35.tar.gz
Algorithm Hash digest
SHA256 656c784be612c0165dec945e9de1066519684b4b8ba7153f7ad44bc3a90aee7b
MD5 c2ed3060e76db6d2ca28073b4aa96a09
BLAKE2b-256 b4ea545d53a58e6318b057cc91bb4df14683fd9c4dc16cd5fe5ab7949b0cd1b0

See more details on using hashes here.

File details

Details for the file pbi_local_connector-0.0.35-py3-none-any.whl.

File metadata

File hashes

Hashes for pbi_local_connector-0.0.35-py3-none-any.whl
Algorithm Hash digest
SHA256 0a8362776e6ebb0bd6068878b97a55f0bec46bcb65121cbc641723835319a5d3
MD5 722ec667cae9b5aa3cedca38f654a73c
BLAKE2b-256 a7caf65ee1bc3ac8caee68c7b99ae6999c8b60b0499cc909fd9878f8264c2ff1

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page