Setup Power BI & EDITable pipeline

We will now build a pipeline in both Power BI and EDITable and walk through the entire deployment process from start to finish.

1. Setup PowerBI deployment pipeline

The first step is to set up a Power BI pipeline. You can refer to this page 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. Learn more about assigning workspaces.

Assign workspaces

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 'Employee_Table' and uploaded it under the Inforiver - Pipeline - Dev workspace.

Publish to the Development stage

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

Deployment pipeline

1. From the first stage, select the report and its corresponding semantic model to be deployed to the test environment. Learn more about deploying reports.

Select items for deployment

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

Start deployment

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.

Deployed to 'Test' workspace

1. Similarly, after the testing stage, you can deploy the report and its semantic model to the production environment using steps 4 and 5. You can refer to the GIF below.

Deploying from Test to Production

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.

Add Pipeline

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

Add stages

1. Click on Add Report.

Add Report

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

Add report IDs

1. The report IDs can be copied from the address bar of the respective workspaces.

Dev Report ID

1. Enter the relevant report IDs of the reports. Click Next.

Enter report IDs for all the 3 workspaces

1. A pop-up appears as below that displays a list of all the available tables or EDITABLE visuals within the selected report. In our example, we only have one visual with a table: 'EmployeeDemo'.

Stages in the EDITable pipeline

1. Click Add to create this EDITable pipeline. Note that in this example, we have configured the same destination for all stages.

EDITable pipeline for a report

1. A report can include multiple tables/visuals, one on each page, which can be added or removed individually in a pipeline during deployment. You can refer to the example below.

Report with multiple tables/visuals

In the following sections, we will look at deploying the report to different stages with the same or different destinations, as well as the various deployment options available in the EDITable pipeline.