Page Comparison

Data

Sources History Overview

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

The Data Source History table contains records of all actions made to the data sources.

Actions Description

The following table describes operations that can be performed with the data source.

Data Sources History Table Columns Description

• Default Columns

• Additional Columns

By default, the Data Source HistoriesSources History table has the following fieldscolumns:

• Action

• Data Source

• Data Source Name

• Data Source Configuration Fields

• Fields, Filters

• Reference Fields

• Table

• User

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

Data Source Histories Table Fields Description

Default

Columns

Default Fields

Additional

Columns

• 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.

Use Case Description

➡️ A user creates a data source with the following data source configuration and export configuration.

The corresponding record appears in the Data Sources History table.

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

Image Removed

• Action: Create → It means a data source has been created.

• Data Source: Use Case Description → This is the referenced field on the Data Sources page that corresponds to the current data source.

• Created: 01/04/2024 03:07:55 → These are the date and time when the data source has been created. The format is the following: dd/mm/yyyy hh/mm/ss.

• Data Source Name: Use Case Description → This is the actual data source name.

• Data Source Configuration Fields: {"Use display value":"false","Data Source Owner":"Liubov Topchyi ","Duration In Seconds":"false","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.

• ":"false","Description":"This data source is created for the test purposes."… → This is the configuration that has been selected by the user during data source creation.

• Table: Data Source [x_acsof_power_bi_s_datasource] → This value is set when actions are not related to changes with tables or fields. During the data source creation, the user just selected tables and fields and didn’t make any changes.

• User: Liubov Topchyi → This is the user name who performed the action.

If you select the Create action (from the previous screen), you can see the detailed description of the Data Source History record. In particular, in the Export Config field, you can see what table and fields have been selected.

➡️ The user then has added one more table with its fields.

After this, one more record appears in the Data Source History table.

• Action: Table Add → It means the user has added an extra table to the data source.

• Data Source: Use Case Description → This is the referenced field on the Data Sources page that corresponds to the current data source.

• Created: 01/04/2024 04:10:50 → These are the date and time when the data source has been created. The format is the following: dd/mm/yyyy hh/mm/ss.

• Data Source Name: Use Case Description → This is the actual data source name.

• Table: Activity Event [sys_activity] → This is the name of the table that has been added by the user.

• Fields: [{"name":"sys_created_on","displayValue":false}… → This is a list of fields that have been added by the user.

• Reference Fields: [] → This value is set when the added table does not include any reference fields. See the Default Fields section.

➡️ Another user decided to export this data source using the OData link.

Another record appears in the Data Sources History table.

• Action: OData Link Click → It means that the user has clicked Copy OData URL.

• Data Source: Use Case Description → This is the referenced field on the Data Sources page that corresponds to the current data source.

• Created: 01/04/2024 04:10:50 → These are the date and time when the data source has been created. The format is the following: dd/mm/yyyy hh/mm/ss.

• Data Source Name: Use Case Description → This is the actual data source name.

• Table: Data Source [x_acsof_power_bi_s_datasource] → This value is set when actions are not related to changes with tables or fields.

• User: Lilli Belward → This is the user name who performed the action.

Useful Tips

How to Find Deleted Data Source

• In the Action Search field, enter Delete.

• You will see a list of all deleted data sources. Here you can find the required data source by its name.

• If you don’t remember the name, you can compare the deleted data source URL and URL in your Microsoft Power BI.

How to View Data Source History for Particular Data Source

1. Find the required data source.

2. Under the Data Source field, select its name.

3. Scroll down and you will records for a particular data source.

How to Clear Data Sources History for Specific Data Source

Status
colour Green title new

1. Via Navigator, find and select Data Sources History (under Power BI Connector for ServiceNow).

2. Find and select the data source you need.

3. Select Clear Data Source History.

4. Select Start Date and End Date, and then select Submit.

How to Clear Data Sources History in Bulk

Status
colour Green title new

1. Via Navigator, find and select Data Sources History (under Power BI Connector for ServiceNow).

2. Select entities of Data Sources History you need.

3. Select Actions on selected rows, and then select Delete.

4. Select Delete.