Connecting PowerBI to Digital Hive Audit Data

Connecting PowerBI to Digital Hive Audit Data

Question

The Digital Hive Control Center doesn't seem to provide any reports or views around usage of the platform. Is there a way to create reports to show metrics like the amount of reports executed by platform, the number of searches being made, who is accessing Digital Hive (and when)?

Answer

The Digital Hive content store provides different views within the database that makes audit reporting very straightforward. While any reporting and analytics platform can be used, this document details what it takes to connect Microsoft PowerBI to the Postgres content store.

For more details about the Digital Hive audit database views: https://support.digitalhive.com/portal/en/kb/articles/default-auditing-explained

1- Within PowerBI desktop, click on the Get data button  
2- From the Get data dialog box, locate the PostgreSQL option, select it, and press Connect.
3- The next step requires configuring the connection details to the PostgreSQL server. Enter the Server address for the DIgital Hive content store 
4- Type digitalhive for the Database name
5- Choose a connection strategy (either Import or DirectQuery)

6- Press OK
7- The next step is to input your PostgreSQL user details, that were created during the Digital Hive install process. 

8- Provide the user name dhadmin and whatever password was configured during the Digital Hive installation.
9- Press Connect
10- If a dialog box called Encryption Support is displayed, just click OK
 
11- The final stage, before data is imported into PowerBI, is to choose the content to be included in the PowerBI data model. Select the 5 audit views:
  1. theia_audit_admin
  2. theia_audit_page_views
  3. theia_audit_search_queries
  4. theia_audit_ui_interactions
  5. theia_audit_user_auth


12- Press Load

You have now successfully imported Digital Hive audit content into Microsoft PowerBI and can now visualize Digital Hive audit data.

Ensure that port 5432 is open and accessible so that the PowerBI server can access the Digital Hive PostgreSQL instance


    • Related Articles

    • Connecting to Microsoft PowerBI

      Question How do we connect Digital Hive to Microsoft PowerBI? Answer As a Digital Hive administrator, connecting to Microsoft PowerBI can be accomplished via the following steps: Connecting Digital Hive to PowerBI requires that an app registration ...

    • Digital Hive Auditing Explained

      Question The Digital Hive Control Center doesn't seem to provide any reports or views around usage of the platform. Is there a way to create reports to show metrics like the amount of reports executed by platform, the number of searches being made, ...

    • Create a Digital Hive Azure App Registration for PowerBI

      Question Are there any prerequisites for connecting PowerBI to Digital Hive so that users can access PowerBI content? Answer Similar to other Cloud based hosted solutions that use REST interfaces, like Google and Box, an Azure AD application to use ...

    • Connecting Digital Hive to Microsoft Engage (formerly Yammer)

      Question How do we connect Digital Hive to Microsoft Engage so that discussion threads can be embedded onto a Hive page? Answer Connecting Digital Hive to PowerBI requires that an app registration has been created within Azure. For more information ...

    • Digital Hive Architecture Overview

      Overview Digital Hive is a lightweight, web-based application that is both easy to install as well as to maintain and manage. Other than the Microsoft C++ redistributable (https://www.microsoft.com/en-ca/download/details.aspx?id=40784), there are no ...