Resources

Power BI SentinelThis is a resources page for you to download useful templates and scripts to help use Power BI Sentinel, as well as run diagnostics to test connectivity prior to setting up Power BI Sentinel.

All files and scripts below remain the copyright of Purple Frog Systems Ltd

Purple Frog are unable to provide support for using Powershell, these scripts assume that you are already familiar with using Powershell.

Usage/Audit Log Power BI Template

This Power BI template file (SentinelUsageLogs.pbit) is a starting point for you to build usage and audit reports.

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

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 datbase

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

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

Data Lineage Power BI Template

This Power BI template file (Power BI Sentinel Data Lineage.pbit) is a starting point for you to build your own reports showing your Power BI Lineage, documentation and permissions.

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 activate the "Enable Lineage Logging" option 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 datbase

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

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

The following downloads are Powershell scripts for advanced users only.

These can help you diagnose problems with your Power BI account or your Azure services that Sentinel uses.

NOTE: Neither Power BI Sentinel nor Purple Frog Systems are able to provide Powershell support, and do not accept any liability for their use. These scripts are provided for your information only and you are responsible for their use.

Setup Test 1 - Power BI

This Powershell script will check your Power BI Tenant to list which workspaces you can see, and what Sentinel functionality you will get for each workspace.

When you run this, it will ask you to log in with your Power BI credentials. You should use the account that you plan to manage Sentinel with.

To download the Power BI Account test script, please click the button below:

Setup Test 2 - Database

This Powershell script will validate the database connection string, as well as testing that the connection has sufficient write and execute privilages against the database.

This is the Azure SQL Database that will store your usage and audit logs.

Before running this, you will need to enter your ADO.NET connection string on line 12.

Note that this will not test the firewall configuration.

To download the database test script, please click the button below:

Setup Test 3 - Storage

This Powershell script will test the validity of your Azure Storage account connection string.

This is the Azure Storage account that will store your backups.

Before running this you will need to enter your storage account connection string.

Note that this will not test your firewall configuration.

To download the storage test script, please click the button below:

Admin - Grant Access to All Workspaces

This Powershell script will grant permissions for the specified user to access all workspaces.

This needs to be run by a Power BI Administrator.

Note that this only works for 'new' style workspaces, not the old 'classic' workspaces.

 

Neither Power BI Sentinel nor Purple Frog Systems take any responsibility or accept any liability for you running these scripts in your environment. They are for information purposes only.

To download the Grant Workspace Access script, please click the button below:

If what you're looking for is not here, please log a support ticket with our helpdesk by emailing us: help@powerbisentinel.com