Python Power BI Report libary

Welcome to pypbireport documentation.

Quick start:

pip install pypbireport

import pypbireport as ppr
report = ppr.PBIReport(pbix_path)
model = ppr.PBIModel(pbix_path)

What

With pypbireport, you can:

• Modify visuals in a Power BI report.

• Add visuals and customize them.

• Add bookmarks in a report to show and hide visuals.

• Access the Power BI model and add measures to the model.

All of this can be done with Python scripting in plain text or in Jupyter notebooks.

This python package provides an interface for Power BI developing by python.

Get started and check some uses case.

Why

Power BI report developing can become boring sometime. Get visuals in right place, modify pages and settings a lot of bookmarks (buttons) behavior in report. Puffs 😣

I was lazy about doing this in the Power BI user interface. 🦥

I wonder one day having some way to coding PBI reports layout in python, so that I run a script and voilà, everything in its place. This package is the result of my willing.

Licensing and Author

Be free to use this module in your Power BI development and don’t hesitate to contact me. Ismael Miranda (ismaelmiranda11@hotmail.com)

Versions

Version	Comment
0.1	Release
0.1.1	Bug fix in create_bookmark_slicer() function
0.2	Power BI model acess and new objects for visual and bookmarks
0.2.1	Power BI Report peformance improvements

Contents:

• Get Started
  • Installation and use
• User Guide
  • Working with Power BI reports
    • Manipulating Visuals
    • Adding a Visual to the report
    • Creating Bookmarks
    • Save changes as a new report
  • Working with Power BI model
    • Model information
    • Add a measure in model using add_measure_in_model
• Code Reference
  • Power BI Report classes
    • PBIXFile
    • PBIReport
    • PBIVisual
  • Power BI Model classes
    • PBIModel
    • Column
    • Measure
    • Table

Indice

Index