Upgraded to new workspace, got sharing problems using "Save a copy"

[Anonymous]

Hi guys,

I just upgraded all my workspaces from classic to the new one. I got troubles using "Save a copy" function.

1) Let's say I published a report to workspace A, then I save a copy to workspace B. Great, the report is in workspace B now. But the viewers in workspace B cannot see it because they do not have permissons!  I have to use "Manage permissions" to add those users to the dataset one by one! 

Since workspace B has quite a lot of users, adding them one by one to each report is a huge pain. Also, we already have RLS. What's the point of copying a report to another workspace but the viewers are not allowed to see it? How can I skip the "Manage permissions" step?

2) Another problem is you cannot replace the copyied report. Again, I published a report to workspace A, then I save a copy to workspace B. I modified the report in BI desktop and publish it. It shows "Replacing this dataset may impact 2 workspaces 2 reports" and I clicked "Replace". Report in workspace A is replaced but not the workspace B. Is it a bug? How can I solve it? 

Thanks for any advice!

[v-robertq-msft]

Hi, @Anonymous 

Here’s my opinion on your questions:

First question:

I think that you can just add an Office 365 group which is created with the classic workspace in "Manage permissions". What’s more, when you make a copy of your report to the other workspaces, it’s dataset connected to the report in live connection mode. As a result, I think the viewers just don’t have access to this report instead of the dataset. I suggest you add the Office 365 group to the new workspace with a viewer role.

Second question:

When you save a copy of a report, the report you saved is an independent report live connected to the original dataset. Therefore, when you replace the original report, the copied report won’t be replaced, but its dataset will change as the original dataset changes. It’s not a bug. I suggest you publish twice to workspace B if you want to.

More info about new workspace in Power BI

Add Office 365 groups as a member to app workspace

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for the reply. For second question, there are two problems with publishing twice. First, I will create another report instead of replacing it. Second, there would be two datasets in workspace A and B.

What I want is just publish / update a report to several workspace. Why that's seem very difficult in BI?

[v-robertq-msft]

Hi, @Anonymous 

As I mentioned before, when you save a copy of a report to other workspaces, the data it displays is live connected to the original dataset, you can not even see the dataset in the target workspace, like this:

In my opinion, publish your reports to your expected workspaces (once in a time), then you can update a report to several workspaces, which is not very difficult.

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.