Data Source Histories

Data Source Histories Overview

Data Source Histories was implemented as a separate page that can be found via navigator.

Only users with an admin role can access the Data Source Histories page, namely ServiceNow [admin] and PBI admin.
Non-admin users - PBI Editor and PBI Viewer - don’t have access to view the Data Source Histories page. However, all their actions with the data source will be logged in the Data Source Histories table.

By default, the Data Source Histories table has the following fields:

Action
Data Source
Data Source Name
Data Source Configuration Fields
Fields, Filters
Reference Fields
Table
User

Default and additional fields.gif

The Data Source Histories table can be configured by selecting the Personalize List option.

Data Source Histories Table Fields Description

Default Fields

Field	Description
Action	The name of an action performed with a data source (Create, Data Source Fields Change, Delete, Fields Add, Fields Change, Fields Delete, Filter Change, Link Click, Table Add, and Table Delete).
Data Source	The referenced field on the Data Sources page corresponds to the current data source. Navigating to it will open the data source page. The value “(empty)” is set when data source has been deleted
Data Source Name	The static text field used to specify the name of a data source in a particular action moment.
Data Source Configuration Fields	The field contains a list of configuration fields that have been changed: Name, Description, Rows Limit, Use field labels for column names, Disable editing for other users, Allow Groups to Edit, Duration in seconds. The field will be empty if no changes have been made.
Fields	The field lists the fields for a particular table that have been changed (e.g. added, deleted, or changed their use display value). The field will be empty if no changes have been made.
Filters	The field shows the modified filter string for a specific table. The field will be empty if no changes have been made.
Reference Fields	The field lists the Reference Fields for a particular table that have been changed (e.g. added, deleted, or changed their use display value). The field will be empty if no changes have been made. For Table Add and Table Delete action where no fields are present, the field will display [].
Table	The field displays the name of the table for which changes were made. The Data Source [x_acsof_power_bi_s_datasource] is set for all actions not related to changes with tables or fields.
User	The field indicates the user who triggered the action, in other words, who made changes.

Additional Fields

Field	Description
Created	The field shows the date when action was triggered (created).
Data Source URL	The field displays the OData link of the edited data source.
Created by	The field indicates the user who triggered the action, which is also represented by the User field.
Export Config	The field contains the full export configuration of the current source, and it’s filled only for Created and Delete actions.
Updated	The field shows the date when an action row was manually updated in the tab;es, exclusively from the backend.
Updated by	The field displays the name of the user who updated the action row from the table, exclusively from the backend. By default, it’s Created by.
Updates	The field shows the number of rows that have been updated, with a default value of 0.
Tags	The field represents the system SN field and is empty by default.

Action Description with Examples

Create - is triggered when a data source is created. The resulting page is static and contains data of the creation moment only. The data on this page will not be changed after the next modifications.

Data Source Fields Change - is triggered when any of the following fields are set, changed, or removed: Name, Description, Rows Limit, Use field labels for column names, Disable editing for other users, Allow Groups to Edit, Duration in seconds.

Delete - is triggered when a data source is deleted. The resulting page is static and contains data only of deletion moment. The data on this page will not be changed after the next modifications.

Fields Add - is triggered when either general or reference fields are added.

Fields Change - is triggered when the use display value is changed for fields, including reference fields.

Fields Delete - is triggered when either general or reference fields are deleted.

Filter Change - is triggered when the filter string is set, changed, or removed. This action generates a separate entry for each saved change and for each table.

OData Link Click - is triggered when the OData URL is copied from the portal.

BlankQuery Template Link Click - is triggered when the BLankQuery Template is copied from the portal.

Table Add - is triggered when a table or database view is added.

Table Delete - is triggered when a table or database view is deleted.