pbi-load-test

Python package and CLI application to measure Power BI reports loading capacity, using different filters and parameters.

It simulates a realistic set of user actions such as changing slicers, filters (soon), bookmarks (soon)

[Prerequisites](#prerequisites) | [Installation](#installation) | [Configuration](#configuration) | [Example](#example)

Prerequisites

• It requires and Azure AD login method. Ensure you have Azure CLI installed locally and authentificate (az login) in order to generate a token easily. Soon:

• This package is based on Selenium python package. It will open a Chromium window to launch the test. In any case, it may require the Chromium driver locally. The latest versions for each OS can be found here.

Installation

With pip

$ pip install pbi-load-test

And to test the installation

$ pbi-load-test --version
0.1.1a1

with poetry

$ poetry add pbi-load-test

And to test the installation

$ poetry run pbi-load-test --version
0.1.1a1

Configuration

The load test is configurated through a config.yaml file which should be located in the current working directory.

# authentification: oauth
workspace: ... # PBI Workspace Name
report: ... # Report name
page: ... # Page name

slicers:
  - table: ... # Table name from dataset which contains the column to filter on
    column: ... # The column name containing the values to filter on
    values:
      - ... # The value to filter on
      - ...

Example

It ensures that a config.yaml file exists in the current working directory

❯ poetry run pbi-load-test run

CORE - MARKETING [DEV]
SFE Country Dashboard TMDL
Activity Field Days
Workspace ID: 310d9fbb-1474-4939-bcb8-669a536ec959
Report ID: c89485c6-e0c3-4715-a710-ddd450491a9a
groups/310d9fbb-1474-4939-bcb8-669a536ec959/reports/c89485c6-e0c3-4715-a710-ddd450491a9a/pages
Page ID: ReportSectioncbd8077dfb6a167ccb5e
Duration: 30.085
Press Enter to continue...

After the test, all created files will be removed.