How do I setup the Audit Trail in PBRS?

An audit trail is a chronological record of changes that have been made to a database or file. PBRS can be configured to create an audit trail that will be stored in a given database. This is how to set it up.

Options - Audit Trail

  • Go to Options.
PBRS Home Menu
  • Select Audit Trail.
Power BI and SSRS. Audit Trail section in Options in PBRS

An audit trail is a chronological record of changes that have been made to a database or file. PBRS can be configured to create an audit trail that will be stored in a given database.

Audit information is not stored in PBRS and you must create and designate an external ODBC compliant database for storage.

The audit trail will display which users have executed, refreshed, or edited schedules.

This audit trail will show common activities, such as which user executed a given schedule, what the user did, the schedule that was manipulated, and the type of schedule.

Enabling the Audit Trail

To allow PBRS to create an audit trail, perform the following:

  • On the Audit Trail tab of the Options window, check the box next to Enable Audit Trail. This will enable the Database Setup fields to be modified.
  • Enter the database name and applicable credentials into the DSN Name, UserID, and Password fields. Then, click Connect.
Power BI and SSRS. Audit Trail section in Options in PBRS
  • If successful, a pop-up will appear: Database connection established. Click OK.
Database connection established in PBRS
  • Click Apply then at the bottom of the Options window to save these settings.