How to connect report templates to Safetica ONE database in Power BI

Learn how to connect the Activity and Data Security Dashboards to your DLP log database in Power BI

Before you can perform the activities mentioned below, you must integrate Safetica with a data analytics tool as described in this article.

There are two report templates you can get from Safetica: the Activity Dashboard and the Data Security Dashboard. To use them in Power BI, you have to connect them to your Safetica database and populate them with data from your DLP logs.

You can download our report templates here.

In this article, you will learn:

  1. How to connect report templates to Safetica ONE database in Power BI
  2. How to update invalid credentials in Power BI
  3. How to change time range for loaded logs in Power BI

How to connect report templates to Safetica database in Power BI

Perform these steps:

HubSpot Video
  1. Open Power BI.
  2. Click the Open other reports.
  3. Select the desired .pbix template (i.e. Activity Dashboard or Data Security Dashboard).
  4. The empty template will open in Power BI. Now you have to connect it to your Safetica database.
  5. Click Transform data in the upper part of the screen.
  6. On the right, in the Applied steps section, click the icon next to Source.
  7. Enter the names of your Safetica server and database.
  8. Next, you can choose your sign-in method. Click Database and enter the credentials for the new account you created in previous steps.
  9. If you see a notice that the connection will not be encrypted, click OK.

  10. Click Close & Apply to save your settings.
  11. Click Refresh. Data from your Safetica database will be loaded into all the three tabs of your dashboard.

How to update invalid account credentials in Power BI

Your account user name and password are stored in Power BI. If you change your password later, the connection to Safetica database will stop working (i.e. the old password will become invalid). To solve this issue and update your credentials:

HubSpot Video
  1. Click File > Options and settings > Data source settings.
  2. Choose the relevant database connection and click Clear Permissions. The stored credentials will be deleted.
  3. Click Refresh in the upper part of the screen and enter your new credentials.

How to change time range for loaded logs in Power BI

By default, only the most recent logs from your Safetica database are loaded into Power BI – the time range is set to the last 30 days.

To change the time range:

  1. Click Transform data in the upper part of the screen.
  2. On the right, in the Applied steps section, click the icon next to Filtered Rows.
  3. Change the time range as desired and click OK.