Rebind reports using a composite model (same workspace)

If you linked your process in your Test environment to a workspace (for example, WkSpace B) that's the same as the one used for the process in your Dev environment (for example, WkSpace A), follow the steps in this article.

Attach a workspace to your process

1. In the Environments dropdown menu at the top of the screen, select your Test environment.

2. On the navigation pane to the left, select Process mining.

   If your process was newly copied over to the Test environment, there's an exclamation mark inside a speech bubble on the process. This mark indicates that the process was imported.

   

3. Select the process, and then select Confirm.

4. If you newly imported the process, continue to step 5. If you didn't newly import the process, go to step 6.

5. Select the same workspace for this process by following these steps:

   1. In the Power BI workspace dropdown menu, select the same workspace as the previous workspace.

   2. In the Report Name field, enter a different report name from your previous report name.

      Important

      The report name must be different from your previous report name.

   3. To continue setting up the process, select Continue.

   

6. (If you didn't newly import the process) Attach a custom Power BI workspace to the process:

   1. Go to the process details page for the process.

   2. On the Details card, select Edit.

   3. From the Power BI workspace (optional) dropdown menu, select your WkSpace A Power BI workspace.

   4. Provide a different report name from the name you used for the process in Dev environment.

      Important

      The report name must be different from the report name of the process in Dev environment.

   5. Select Save > Continue.

   6. From the command bar or in the report view, select Refresh data.

7. Sign in to Power BI.

Before you get started, ensure that the states of your reports, workspaces, and their lineages correspond to what's in the following sections.

State of your WkSpace A

Your WkSpace A should have the following entities:

The numbering corresponds with the numbering of entities in the following screenshot.

There are three (3) entities titled 'Report A'. You can differentiate them using their icons and their Refreshed timestamps:

• The icon with the yellow bars represents the reports and the other icon is that of the composite model or semantic model.

• The report with the same Refreshed timestamp as the composite model is the report of the composite model.

  

Your lineage view should look like the following screenshot:

Rebind the report in Power BI

1. Sign in to Power BI.

2. Navigate to your WkSpace A.

3. From the list of entities, select the three dots beside the composite model, and then select Download this file.

   

4. In Power BI desktop, open the downloaded file.

5. From the File menu, select Save as and give the report a new name such as Report B.

6. From the home tab, select Transform data > Data source settings. Notice the Direct Query connection in the Data source settings.

7. Select Change Source.

8. Search for and select the semantic model of the process that's in your Test environment. The semantic model is Report B_Dataset_206… and it should be in your WkSpace A.

9. Select Create.

   

10. When the Connect to your data message appears, select relevant tables, and then select Submit.

11. When the query changes are applied, select Close.

12. Save the report.

13. From the Home tab, select Publish.

14. Select your WkSpace A as the destination, and then choose Select.

15. When the publishing completes, go to your WkSpace A in Power BI to confirm the changes are applied.

    The lineage view now shows the composite model.

    

16. Select the Report B that the composite model points to. It's the second red box in the previous image.

17. Select Open report.

    The report looks like that of the composite model from WkSpace A with the Self Loop percentage in the report.