Power BI Report Templates

Usage and Audit Log Power BI Template

To download the SentinelUsageLogs.pbit file, please click the button.

This Power BI template file is a starting point for you to build reports showing your organisation's Power BI usage consumption, adoption and activity audit data.

[Last updated 19th October 2023]

Data Lineage and Documentation

To download the "Power BI Sentinel Data Lineage.pbit" file, please click the button.

This Power BI template file is a starting point for you to build your own reports showing your Power BI Lineage, documentation, permissions and dataset refresh history.

[Last updated 26th January 2023]

When you open the file it will ask you for the SQL Server name and Database name for your Sentinel logging database.

Before using this, you need to ensure you've connected your Azure SQL Database into Sentinel, in the "Configure" screen of your Power BI Sentinel portal. The tables will be created overnight, and the content updated daily.

Please feel free to adapt this to your own needs as you see fit.

To use this template you just need to open it in Power BI Desktop, and enter your Azure SQL Database details (server name & database name), and then authenticate using the username and password that you entered when setting up the database.

Common problems:

  • Your IP address hasn't been allowed through the database server's firewall
  • Make sure you're using the username and password entered when creating the database
  • OR grant your own user account appropriate rights to query the database
  • Try creating a new Power BI report to connect to the database

Neither Power BI Sentinel nor Purple Frog are able to provide technical support for your database setup.