Copy a Power BI report to a shared workspace

Modified on Tue, 17 Nov at 9:19 AM

Print

Copy a Power BI report from your own workspace to a shared workspace in Power BI, so that more than one person can update it. You also need a shared workspace to schedule a Power BI report: the TS Autopilot can only reach the report there.

Before you start

The steps use this example: a report named "Balance Report" in TS, with a semantic model (dataset) named "Balance Report" and a report layout named "Balance Report Power BI Web" in My Workspace.

On the report's Overview tab in TS, Power BI Web Display Names shows these names.

The Balance Report in TS, with Report viewer set to Power BI and the Power BI report, dataset and workspace display names highlighted: Balance Report Power BI Web, Balance Report and My Workspace

In Power BI, My workspace holds the semantic model and the report.

My workspace in Power BI, listing the Balance Report semantic model and the Balance Report Power BI Web report

The report layout, "Balance Report Power BI Web", uses the "Balance Report" semantic model.

The Balance Report Power BI Web report open in Power BI, a table of deals, with its name at the top left and the Balance Report semantic model highlighted in the Data list

Steps

Make a copy of the report in TS

The copy takes over the original report's name. The semantic model gets its name from the report in TS, so the copied semantic model is also named "Balance Report".

  1. In Reports, rename the original report, for example to "Balance Report-original".

    The reports list in TS, with the original report being renamed to Balance Report-original

  2. Select Copy. TS adds a copy named "Balance Report-original - Copy".

    The reports list in TS, with the new copy, Balance Report-original - Copy, highlighted under Balance Report-original

  3. Rename the copy to the original report's name, "Balance Report".

    The reports list in TS, with the copy being renamed to Balance Report

  4. Select Save.

Copy the report layout to the shared workspace

  1. With the copy selected, select Run. The Run as Power Bi window opens and says the report has no associated Power BI report.
  2. In Workspace, choose the shared workspace.
  3. In Select Power BI report layout to copy, choose the original report's layout, "Balance Report Power BI Web".

    The Run as Power Bi window for the copy in TS, with a shared workspace and the report layout Balance Report Power BI Web selected

  4. Select OK.

Result

TS shows a copy of the report layout, named "Balance Report Power BI Web- Copy".

The copied report shown in TS, in a tab named Balance Report Power BI Web- Copy, a table of deals

In Power BI, the shared workspace now holds copies of the semantic model and the report layout.

The shared workspace in Power BI, listing the Balance Report semantic model and the Balance Report Power BI Web- Copy report

Give others access to the report

For colleagues to update the report, they need access in both TS and Power BI.

  1. In TS, share the report with them. See Share a report.
  2. In Power BI, give them access to the shared workspace.

To schedule the report, the TS Autopilot needs the same access. See Set up scheduled Power BI reports.

Delete the original report

Once the copy works, delete the original report in TS.

Rename the copied report layout

You can give the copied layout a new name in Power BI.

  1. In the shared workspace, select the three dots (...) next to the report.
  2. Select Settings.

    The menu that opens from the three dots next to the copied report in Power BI, with Settings highlighted

  3. In Report name, enter the new name.

    The Settings pane for the copied report in Power BI, with a new name entered in Report name

  4. Select Save.

TS shows the new name the next time you run the report.

The report shown in TS, in a tab with the new name, Balance Report Power BI Web- New name

Related articles

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article

More in Reports

Still need help? Reach people who already know your configuration.

Submit a ticket