Inforiver
EDITable
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. Set up PowerBI deployment pipeline
  • 1.1. Deploy report to the next stage
  • 2. Set up EDITable deployment Pipeline
  • 2.1. Add report to pipeline
  • 2.2. Deploy report to the next stage
  1. Admin Portal & EDITable Console
  2. Utility
  3. Pipeline

Power BI & EDITable deployment pipelines

PreviousPipelineNextDeployment in different destinations

Last updated 3 months ago

We will now create a pipeline in both Power BI and EDITable, and walk through the entire deployment process from beginning to end.

In this section, we will deploy the report in stages that use the same destination. This can be useful when you want to maintain version control for your EDITable visuals before sharing the final version of your content with business users across the organization.

1. Set up PowerBI deployment pipeline

The first step is to set up a Power BI pipeline. You can refer to to get started.

  1. After creating a pipeline, you can assign workspaces to each stage, i.e., the Development/Test/Production stages of the deployment pipeline. .

  1. Let us assume you have a Power BI report with an EDITABLE visual that you want to deploy in stages. Publish it to the workspace mapped to the first stage (development) of the pipeline.

For this demonstration, we have created a report named 'EmployeeDetails' and uploaded it under the Inforiver - Pipeline - Dev workspace.

1.1. Deploy report to the next stage

  1. Go to the Deployment Pipelines tab and select the required pipeline that you created in step 1.

  1. Review the items that are being deployed and click on the Deploy button.

  1. After the deployment is complete, you will be able to see the report and the semantic model in the next stage. In this case, it is the Inforiver - Pipeline - Test workspace.

  1. Similarly, after the testing stage, you can deploy the report and its semantic model to the production environment by repeating the above steps.

When deploying reports, please ensure to deploy their corresponding semantic models.

2. Set up EDITable deployment Pipeline

  1. In the EDITable workspace, go to Utility > Pipeline. Click on Add Pipeline.

  1. Click on Add Stage and you can start adding the required stages — Dev, Test and Prod.

2.1. Add report to pipeline

  1. Click on Add Report.

  1. A pop-up appears as shown below, based on the number of stages created.

  1. The report IDs can be copied from the address bar of the respective workspaces. The image below illustrates how the report ID can be obtained from the report in the 'Dev' workspace.

  1. Similarly, enter the report IDs for each workspace report. Click Next.

  1. A pop-up window appears, displaying a list of all EDITABLE visuals (tables) included in the selected report.

Our report contains only one visual/table, 'EmployeeDetails'. Click Add to add this report and create an EDITable pipeline.

A report may also contain multiple tables/visuals, one on each page, that can be added to or removed from a pipeline during deployment. You can refer to the image below, where the report has multiple EDITable visuals.

2.2. Deploy report to the next stage

  1. To deploy a report from one stage to another, such as 'Dev' to 'Test' or 'Test' to 'Prod', click the Deploy button next to the report you want to deploy.

  1. Select the next stage for deploying the visual from the dropdown menu.

  1. Click Deploy.

  1. The report is now deployed from 'Dev' to 'Test' stage. Similarly, after testing, you can deploy the report from the 'Test' to the 'Prod' stage by repeating the above steps.

In the next section, we will look at the steps to deploy the report in stages that use different destinations.

From the first stage, select the report and its corresponding semantic model to be deployed to the test environment and click Deploy.

Note: In this example, we have deployed the reports to the same destination (Azure SQL) for simplicity. The will explain how to configure different deployment destinations.

Learn more about deploying reports.
next section
this page
Learn more about assigning workspaces
Assign workspaces
Publish to the Development stage
Deployment pipeline
Select items for deployment
Start deployment
Deployed to 'Test' workspace
Deploy to next stage
Deployed to production
Add Pipeline
Add stages
Add Report
Add report IDs
Dev Report ID
Enter report IDs for all the 3 workspaces
Add report to the EDITable pipeline stages
EDITable pipeline for a report
Report with multiple tables/visuals
Deploy a report
Choose stage to deploy
Deploy