Tables
Last updated
Last updated
This section displays a list of tables configured in the EDITable visual on the left pane and their corresponding configuration details on the right side when clicked on each one of them.
Use the search box to quickly search for the required table.
Upon selecting a specific table, the user can view three main items corresponding to that table: general details, approvals, and transaction logs.
This page shows the column and connection details of the table.
Column Details: This section contains information about the columns in the table, such as column names, their data type, default values if they are configured, null/not-null property, any set constraints, relation, etc.
Connection Details: The following connection details can be seen from this section:
Connection Type: The type of connection (e.g., Fabric Warehouse, Azure SQL, Snowflake, BigQuery, etc.).
Account: Account information associated with the table.
Username: The user who created or manages the table.
Created At: Timestamp of when the table was created.
Updated At: Timestamp of the most recent update to the table.
Updated By: The user who last updated the table.
Reports: This part lists all published reports that use this connection and table, with their URL.
This page lists all approvals related to transactions involving the particular table. Here, you can track each approval's status and complete details of the request, such as the ID, requested user, approvers, created time, and reviewed time.
Search: You can search for specific approval requests using the search option.
Filter: You also have the option to filter approvals based on the requested user, status, approver, requested time, and reviewed time.
Download or delete the report by clicking on the options Download Report and Delete Report respectively.
This tab logs all transactions made to the selected table and provides a historical record of changes for auditing and tracking purposes. You can view the complete details of every transaction, including the job ID, transaction type, number of rows affected, duration, status, the user’s name, and the time it was completed.
Search for a transaction using the search option.
Filter transactions using the ID, transaction type, user's name, status, start time and the job type.
Download or delete the report by clicking on the options Download Report and Delete Report respectively.
Click on any job ID to view detailed information about the transaction and the milestones with their respective duration and timestamps as below:
Use the Download Report option to download the PBIX report of the created table.
To delete the report, use the Delete Report option.
This will delete the table configuration from the associated EDITable visuals, and you'll have to reconfigure them from scratch. Click Proceed only if you are sure.