Reporting using Power BI
How to Install Power BI
Power BI, a powerful data visualization and reporting tool from Microsoft, is free to use for desktop users. To download Power BI Desktop, visit the official Microsoft download page: Power BI Desktop Download.
For optimal performance, it’s recommended to select the 64-bit version.
Start from the Peripass Power BI template
Download the template
The following Power BI template can be used to quickly generate a dashboard through the Peripass API:
Dashboard Peripass API v08.pbit
Enter the parameters
Upon opening this template, you’ll be prompted to provide the following details:
Tenant: Specify the tenant for which you want to create the dashboard.
API Key: Enter the API key associated with this tenant.
Period options
You have two options to specify the period of interest:
Validity Period: Use the following date format for both from and until dates:
YYYY-MM-DDExample: 24/01/01
Slot Start: Use this format if you need precise timestamps:
YYYY-MM-DDTHH:MM:SS±HH:MMExample: 2024-10-08T00:00:00+02:00
To generate a report for a specific period, please enter the desired start and end dates in the "from" and "until" fields. Remark that you can change the selected reporting period later. See further.
If you would like the report to include data up to the current date, simply enter "Today" in the "until" field. This will automatically pull data through the present day, allowing you to easily refresh and update your report with the latest information.
Connect and approve anonymous access to the data source
Note that you will have to click “Connect” on the dialog pictured below when using a tenant for the first time.
Start browsing your data
When that is done, your dashboard should automatically be populated with the relevant data and look something like this:
Please note that a second tab is available specifically for multi-site tenants, allowing for a comparison of site performance.
Won’t do / limitations
Data scope is limited to 15 000 visitors
To avoid too much impact on the load of our database, the maximum number of visitors that can be included in the scope of the data report is limited to 15 000. When trying to fetch more visitors, it will just stop after 15 000. The user will get a hint that not all visitors in the time scope could be loaded.
Less than 15 000 visitors in selected time frame (5 487) | Max number of visitors reached (warning) |
|---|---|
 |  Number of visitors loaded marked in red (max amount reached) |
Troubleshooting
Finding your API key
In Peripass , go to “Configuration” > “General settings” > “Integrations”. Here you should be able to locate your API key.
Changing the date filters
The date filter in the upper left corner is default set to display the visitors that arrived in the last 2 months. You can change this date filter to any other relative filter.
Updating the dashboard with a new reporting period after initial setup
Upon first using the template, you’ll be prompted to enter parameters, including your desired start and end period. Once you close Power BI, you'll have the option to save the report with your initial settings.
If you have selected a specific reporting period, please follow these steps to adjust the dates:
Restart from the Template: Start fresh with the template to enter new parameters.
Edit the Parameters (Advanced): Update parameters directly within Power BI:
Go to Transform Data and choose Edit Parameters
Correct start or end period
