Edit

Share via

Rebind reports without using a composite model (different workspaces)

If your process in the Test environment is connected to a different workspace (for example, WkSpace B) than the one used in the Development environment (for example, WkSpace A), follow the steps in this article.

Attach a workspace to your process

Take these steps to attach a workspace to your process:

  1. In the Environments dropdown menu at the top of the Power Automate 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.

    Your process mapped out on the Process Mining home page.

  3. Select the process, and then select Confirm.

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

  2. Select the type of workspace to be used - Power BI workspace or Fabric workspace

    1. The dialog informs you whether you originally exported the process to Power BI or Fabric workspace

    2. In this step you can decide to change the destination to not match the original setup

      Important

      The semantic model structure is different for Power BI workspace and for Fabric workspace. This might potentially result in problems in your report visualizations, that must be resolved manually.

    3. Select Continue

  3. Select a new workspace for this process by following these steps:

    1. For Power BI workspace - in the Power BI workspace dropdown menu, select a different workspace, which you'll use in the Test environment.

    2. For Fabric workspace - in the Fabric workspace dropdown menu, select a different workspace, which you'll use in the Test environment, in the Lakehouse dropdown menu select the destination Lakehouse.

    3. In the Report Name field, enter the same report name as your previous report.

      Important

      The report name must be identical to your previous report.

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

      Screenshot of selecting a new workspace for your process with the same report name as your previous report.

  4. (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 B Power BI workspace that you want to migrate customizations to.

    4. Provide the same report name as the name you used for the process in Dev environment.

      Important

      The report name must be identical to 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.

Rebind the Power BI report

Take these steps to rebind the Power BI report:

  1. Sign in to Power BI.

  2. From the left navigation pane, select Workspaces > your WkSpace A.

  3. In your WkSpace A, select your Report A.

  4. To download the report, select File from the command bar > Download this file > "A copy of your report with a live connection…" > Download.

  5. Open the downloaded report in Power BI for desktop.

  6. After you edit the report, select Transform data > Data source settings from the command bar in the Home tab.

  7. Select the semantic model of the process that's in your WkSpace B workspace from the list of semantic models, and then select Connect.

    This is called rebinding. The report refreshes. Learn more about semantic models in Semantic models in the Power BI service.

    Screenshot of rebinding your process after you download, edit, and connect your model.

  8. From the command bar, select Save to save the report.

  9. From the command bar, select Publish to publish the report.

  10. From the Publish to Power BI menu, select your WkSpace B > Select.

    A message that says Replacing report appears because you retained the report name.

  11. Select Replace to overwrite the old report in WkSpace B. This action overwrites the existing report with an updated version that incorporates the new customizations. It also preserves the original report name for consistency.

    Screenshot showing how to replace a report.

  12. When this process completes, return to Power BI and open WkSpace B.

    The report is now successfully migrated from WkSpace A and is connected to the semantic model of the process you had in your WkSpace B.