EDITable
  • Introduction to EDITable
    • Why EDITable?
    • Supported Database Connections
  • Get Started
    • EDITable Pre-requisites
      • Admin consent for EDITable's Entra ID
        • Basic consent
        • Full admin consent
    • Install EDITable
    • Add EDITable visual
  • Getting Data into EDITable
    • Connect to Data
      • Get data
      • Assign fields
      • Configuration Steps
        • Configure source
        • Configure Columns
        • Configure Type 2 SCDs (Optional)
    • Create a Table
      • Create From Scratch
      • Use Existing Table
      • Import Data
  • Working with EDITable
    • EDITable interface
    • Manage Columns
      • General
      • Constraints
      • Lookup and Relation
      • Display
      • Import/Export Configuration
      • Add Database Column
      • Insert Column
    • Column Access Control
    • Row Identification
    • Table Operations (Insert/Update/Delete)
      • Edit data
      • Bulk Edit
      • Find and Replace
      • Insert rows
      • Insert Column
      • Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
      • Reset Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Group Rows By
      • Summarize Column
    • Basic formatting
    • Conditional Formatting
  • Row Access Control
  • Approval Workflow
    • Review Changes - Workflow process
  • Type 2 SCDs
    • Configuring Type 2 SCDs in EDITable
  • Audit logs
  • Webhook
  • Display Settings
  • Commenting and Collaboration
    • Assign users & task status
    • View all comments & track changes
    • Comment Settings
  • Admin Portal & EDITable Console
    • Tables
    • Transaction Logs
    • Insights (Metrics)
    • Utility
      • Download Report
      • Pipeline
        • Power BI & EDITable deployment pipelines
        • Deployment in different destinations
        • Trigger deployment pipeline from external applications
        • Logs & other pipeline options
    • Manage Profile
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • EDITable managed DB
        • API token
    • Onboarding Actions
  • Formula and Functions
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEIF
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • LOG
      • MAX
      • MIN
      • PCT
      • POWER
    • Text formatting functions
    • Date functions
      • DATE
      • DATE.FORMAT
    • Other operators
  • Keyboard Shortcuts
  • Release Notes
    • EDITable - v1.7.5
    • EDITable - v1.7
    • EDITable - v1.6.5
    • EDITable - v1.6
Powered by GitBook
On this page
  • New
  • 1. Rule-Based Access Control for updating and deleting rows
  • 2. Bulk update rows by importing CSV or Excel files
  • 3. Import and Export Column Configurations
  • 4. The 'Summary' option in columns for aggregate column summary
  • Enhancements
  • 1. AD group support in approvers list
  • 2. Included the 'Submit for Review' option for rule-based approvals
  • Enhancements in EDITable console
  • 3. Create EDITable reports for existing tables—right from the EDITable console
  • 4. Table creation in the console: Configure input type, lookup and relations, description and default value
  • 5. Option to select a specific sheet from Excel to import data
  • 6. Download multiple tables as a single PBIX report with each table on a page
  1. Release Notes

EDITable - v1.6

PreviousEDITable - v1.6.5

Last updated 5 months ago

New

1. Rule-Based Access Control for updating and deleting rows

You can now define specific rules that grant permission for particular users to update or delete designated rows in the database. This feature improves data security and allows more granular control over data.

2. Bulk update rows by importing CSV or Excel files

  • You can now update multiple rows at once by importing CSV or Excel files, similar to how you bulk-import new rows. The rows are updated based on matching primary keys from the file.

  • We have included two options here - 'Update' with which you can update existing rows and 'Insert and Update' when you need to insert new ones and modify the existing ones.

3. Import and Export Column Configurations

You can now export a saved column configuration to a flat file and import it back into a similar table in the visual. This feature allows you to replicate configurations easily, saving time by avoiding configuring everything from scratch. Please refer to this section to know more.

4. The 'Summary' option in columns for aggregate column summary

The new 'Summary' option provides a quick overview of column values, including the number of empty values, unique values, filled values, percentage of empty/filled/unique values, date range, earliest date, latest date, and so on.

This allows you to quickly identify any data anomalies, such as missing data or unique values, as well as perform simple categorical analyses on large datasets, such as percent of empty rows, percent of unique values, date range, earliest and latest dates, and so on.

Enhancements

1. AD group support in approvers list

You can now add AD groups (Active Directory groups) in the approvers list for Default and Rule-based approvers types.

2. Included the 'Submit for Review' option for rule-based approvals

Previously, the 'Submit for Review' option was available only when approvers were set manually (Default method). This option has now been extended to rule-based approvals.

Enhancements in EDITable console

3. Create EDITable reports for existing tables—right from the EDITable console

Usually, EDITable lets you connect to an existing database from a Power BI report, after which you can start editing the table. Now you can create and download EDITable .pbix reports for existing database connections directly from the console by clicking the option below:

If the table has already been configured in EDITable, you'll be prompted to confirm whether the existing configurations can be restored. Clicking on Proceed restores the configuration from EDITable.

4. Table creation in the console: Configure input type, lookup and relations, description and default value

While creating a table from the console, you can configure the input type, lookup and relations for single-select/multi-select input, description, and default value directly from the EDITable console.

5. Option to select a specific sheet from Excel to import data

In the EDITable console, when you want to import data from an Excel file to create a table, you can choose the specific sheet you wish to import. Previously, 'Sheet1' would be automatically selected for import, by default.

6. Download multiple tables as a single PBIX report with each table on a page

We have added a 'Download Report' option in the console, allowing you to download multiple tables from a connection into a single PBIX report.

Rule-based access control for updating and deleting rows
Bulk-update rows
Import the exported configuration
Adding AD group in approvers list
Create EDITable reports for existing tables from the console
Restore configuration
Configure input type, lookup and relations from the console
Select a sheet to import
Download multiple tables in a single PBIX report