PBI-dashboard-creator 1.0.67

Automatically create PowerBI dashboards using the .pbir file type

PBI-dashboard-creator

This is a python module that can be used to automatically create PowerBI dashboards using the .pbir file type

prerequisites

1. python 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).

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/PBI_dashboard_creator

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. Install the package from a wheel stored in the repo we cloned from github in step 2.

py -m pip install PBI_dashboard_creator/dist/pbi_dashboard_creator-1.0.65-py3-none-any.whl

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

py PBI_dashboard_creator/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