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 5 days ago

There are two ways to connect to existing data in the databases:

  1. From the Power BI Report: Use the Get Data option in Power BI to connect to the data through Direct Query mode.

  1. From the Editable Console: Select 'Create Table' and choose Use Existing Data. The detailed steps are available .

In this section, we will focus on connecting to an existing database using the EDITable visual in Power BI. This process involves the following steps:

All these are explained in the upcoming sections.

Get Data
Assign fields
Configuration Steps
PreviousGetting Data into EDITableNextGet data
  1. Getting Data into EDITable

Connect to Data

here
'Get data' option in Power BI
Get data from the console