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
  1. Get Started
  2. EDITable Pre-requisites
  3. Admin consent for EDITable's Entra ID

Basic consent

PreviousAdmin consent for EDITable's Entra IDNextFull admin consent

Last updated 1 month ago

When users login to the EDITable portal for the first time, admin consent will be required to authenticate the user. The portal utilizes EDITables’s Entra ID app to authenticate the user, and admins need to provide consent for users to be able to login.

STEP 1: Admins can directly navigate to the consent URL.

https://login.microsoftonline.com/common/oauth2/v2.0/authorize?client_id=91891913-3884-46d3-bb4c-f68d33f43d4b&response_type=code&redirect_uri=https%3A%2F%2Faddons.inforiver.com%3A443%2FRedirect&response_mode=form_post&scope=https%3A%2F%2Fgraph.microsoft.com%2FUser.ReadBasic.All https%3A%2F%2Fanalysis.windows.net%2Fpowerbi%2Fapi%2FReport.Read.All https%3A%2F%2Fanalysis.windows.net%2Fpowerbi%2Fapi%2FDataset.Read.All https%3A%2F%2Fanalysis.windows.net%2Fpowerbi%2Fapi%2FWorkspace.Read.All https%3A%2F%2Fgraph.microsoft.com%2FGroup.Read.All https%3A%2F%2Fgraph.microsoft.com%2FGroupMember.Read.All&prompt=consent

Users can either use the Copy Link option highlighted in the screenshot below or open the consent URL and share it with the admin.

STEP 2: Admins can approve the permissions listed in the screenshot to allow users to login.

STEP 3: Additional permissions are required to add functionalities like inviting other users in the organization and connecting to Power BI with EDITable. Admins can navigate to the consent URL:

https://login.microsoftonline.com/common/oauth2/v2.0/authorize?client_id=91891913-3884-46d3-bb4c-f68d33f43d4b&response_type=code&redirect_uri=https%3A%2F%2Faddons.inforiver.com%3A443%2FRedirect&response_mode=form_post&scope=https%3A%2F%2Fgraph.microsoft.com%2FUser.ReadBasic.All https%3A%2F%2Fanalysis.windows.net%2Fpowerbi%2Fapi%2FReport.Read.All https%3A%2F%2Fanalysis.windows.net%2Fpowerbi%2Fapi%2FDataset.Read.All https%3A%2F%2Fanalysis.windows.net%2Fpowerbi%2Fapi%2FWorkspace.Read.All https%3A%2F%2Fgraph.microsoft.com%2FGroup.Read.All https%3A%2F%2Fgraph.microsoft.com%2FGroupMember.Read.All&prompt=consent

Admins need to provide all the permissions shown in the screenshot and check the ‘Consent on behalf of your organization’ option.

Note: After clicking Accept, admins may get a ‘Login Failed’ page, this is expected behavior if they aren’t a member of the EDITable portal.

STEP 4: After providing permissions, the EDITable Entra ID app’s permissions page in the Enterprise Applications section should look like this.

Admin approval notification
Permissions required for user login
Power BI related permission
EDITable Entra ID epp permission page