Inforiver
EDITable
Reporting & Writeback Matrix DocsInforiver Writeback Matrix On-PremAnalytics+EDITableSuper Filter
EDITable
Reporting & Writeback Matrix DocsInforiver Writeback Matrix On-PremAnalytics+EDITableSuper Filter
  • 👋Introduction to EDITable
    • Why EDITable?
    • Supported Database Connections
  • Get Started
    • EDITable Pre-requisites
    • 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
    • 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 & track task status
    • View all comments & track changes
    • Comment Settings
  • Admin Console
    • Tables
    • Transaction Logs
    • Insights (Metrics)
    • User Management
    • Settings
      • General Settings
      • Writeback Settings
        • Add & Manage Connections
        • Database Connections
          • Amazon Redshift
          • Azure SQL
          • BigQuery
          • Databricks
          • EDITable managed DB
          • Fabric Warehouse
          • PostgreSQL
          • Snowflake
        • Settings
        • EDITable managed DB
    • Onboarding Actions
    • Manage Profile
  • 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
Powered by GitBook
On this page

Last updated 6 days ago

Before you set up EDITable, you must complete the following additional steps with your Power BI administrator:

  • EDITable is an add-on visual that operates on top of the Power BI framework, so users must log in with their Microsoft O365 account.

  • Network firewalls block connections from IP addresses that do not have permission. You need to whitelist EDITable's outbound IPs in your Azure SQL database firewall rules.

  • EDITable connects to data sources only through DirectQuery. Please ensure to select DirectQuery in Data Connectivity mode when you are connecting to data. To learn more, you can check out these pages: and .

About DirectQuery in PowerBI
Connect using DirectQuery
PreviousGet StartedNextInstall EDITable
  1. Get Started

EDITable Pre-requisites