Power Bpy

Do you wish you could build dashboard with python or R, but can’t because the client specifically asked for Power BI or your employer only supports publishing Power BI? Do you love love love Power BI, but wish there was a way to automatically generate parts of your dashboard to speed up your development process?

Introducing Power Bpy, a python package that lets you create Power BI dashboards using functions 💪 instead of a point-and-click interface 🥹. Dashboards created using these functions can be opened, edited and saved normally in Power BI desktop.

This package uses the new .pbip/.pbir format with TMDL enabled. This stores dashboards as directories of text files instead of binary files letting you version control your dashboards! 🥳 These features are still preview features, so use this with caution until there’s more clarity from microsoft about what they’re going to do with .pbir and tmdl.

Features

Currently the package has functions that let you do the following without opening Power BI 🥳:

• Create a new dashboard
• Import data from
• csv file stored locally
• csv file stored in Azure Data Lake Storage (ADLS)
• Power BI table stored as a Tabular Model Definition Language (TMDL) file
• Add a page
• Add background images to a page
• Add visuals to a page
• charts
• slicers
• cards
• maps
• text boxes
• buttons

Dependencies

Before you can start to build power BI dashboards using this package’s functions you’ll need the following:

1. Python (version 3.12 or higher!) and pip installed and on path
2. Git installed and on path
3. Power BI Desktop (You can create the dashboards without this, but not view them).

Power BI settings:
You’ll need to enable some preview features in Power BI Desktop. Navigate to File > Options and Settings > Options > Preview features and enable the following options:

1. Shape map visual
2. Power BI Project (.pbip) save option
3. Store Semantic Model using TMDL format
4. Store reports using enhanced metadata format (PBIR)

Run the example

This example assumes you are on windows. All the code below should be entered in command prompt or put in a batch script.

1. Create a new folder to store all the files you’ll need.
   

:: create a new folder
mkdir automatic_PBI_dashboards_example

:: move into the new folder
cd automatic_PBI_dashboards_example

2. Clone the files from github.
   

git clone https://github.com/Russell-Shean/powerbpy

3. Activate venv.
   The following is taken from this tutorial. We’ll use venv to install the python package in an isolated environemnt.
   

:: create a virtual environment
py -m venv .venv

:: activate the virtual environment
.venv\Scripts\activate

:: For extra credit, verify that venv is working
where python

4. Make sure pip is installed and up-to-date.
   Pip is the tool we’ll use to install the package.
   

:: install and/or upgrade pip
py -m pip install --upgrade pip

:: check version number (and confirm it's working)
py -m pip --version

5. Install the package.
   This package isn’t on pypi yet, so you’ll need to install it from Github
   

```dosbat     
py -m pip install git+https://github.com/Russell-Shean/powerbpy.git#egg=powerbpy     

After the package is on pypi, you’ll be able to install it using this:

py -m pip install powerbpy

6. Create the example dashboard. Run an example script to generate an example dashboard.

py powerbpy/examples/create_example_dashboard.py

7. Open the dashboard.
   Open the dashboard to confirm everything worked.

start test_dashboard/test_dashboard.pbip

8. Refresh data models

After Power BI opens, you’ll see a banner that looks like this:

Click Refresh now

If everything worked you should have a dashboard that looks like this:

image

image

Next steps

The code used to generate the dashboard is stored here
Try building your own dashboards with these functions and let me know what happens!

Feedback

I welcome the following feedback:

1. Pull requests to add features, add tests, fix bugs, or improve documentation. If the change is a major change create an issue first.
2. Issues to suggest new features, report bugs, or tell me that the documentation is confusing 😅
3. Power BI feature requests. I need help from Power BI developers who don’t neccesarily have experience with python or github. I don’t really know Power BI 😅, so please feel free to suggest new features. It would be really helpful if you could include a .pbix file that has the feature or even better a git diff of the dashboard before and after the change.(Use the .pbip format)