History Overview in Power BI

This Power BI template can be used with your Data Reporting Server to provide an overview of History data.

Setup

This report can only be used with the Data Reporting Server.

1. Download and unzip the report template from the downloads area of this article
2. Make sure you have the details of your:
   • Database server
   • Database name
   • Database user and password
3. Open the report template by double clicking on it. This will launch Power BI desktop. You'll be prompted to enter the following details
4. Enter the server and database name
   

5. Run the query
   

6. Enter the username and password into the "Database" tab
   

7. Allow the unencrypted connection
   

8. Power BI will now connect to the server and load your data into the report
9. Save the report and publish as normal

What it Shows

The dashboard provides a count of each type of history (ie each unique "labela") and also a count of type by year.

You can view a breakdown by year, which provides a count of each history in that year and also the type of history by "labelc".

You can also view a report by type of history to see a year on year comparison.

Labelc Filter

Rather than show every "labelc" value, we have grouped them into sensible categories.

• audit and reporting are our standard labelc values
• product groups together the standard email, notes and attachments labels
• any other labels are grouped under other