Cannot Republish Report Using Shared Dataset To Service

[alindquist]

I built a report using a Power BI dataset as the data source. I was able to publish this report to a new workspace (different than the workspace that holds the dataset), but after publishing I am not able to publish and replace the report. When I try to publish and replace the existing report I get the following error message:

I tried upgrading to the latest version of Power BI Desktop but I still get the same error. I also tried deleting the report from the service then publishing it again. The first time I publish it, it is successful but when I try to publish and replace again I get the same error message. How can I resolve this issue?

[alindquist]

@collinq I had a report in the same workspace as the dataset with the same name as the new report I was trying to publish to the separate workspace. When I renamed the new report I stopped getting the issue. That makes sense that it would initially publish but error out when I tried to republish, since it wouldn't know which report to replace.

[alindquist]

@collinq ok, that sounds like it's not the problem I'm having then. I am able to publish the report to a different workspace already with no issues. The error comes up when I want to publish updates to that report that I have already successfully published to the separate workspace.

[collinq · Accepted solution]

Hi @alindquist ,

Is this an embedded report/dashboard?  And, do you have multiple dataset with the same name?

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[collinq]

HI @alindquist ,

You will need to get with your Power BI Admin to determine if this is allowed.  They may have the ability to publish datasets across workspaces as disabled.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[alindquist]

@collinq would that only affect publishing and replacing a report using a dataset from a different workspace? I am able to publish the report to a different workspace than the dataset, the error comes when I try to publish and replace the report after initially publishing it.

So for example, the dataset is in workspace A. I built the report using that dataset as the data source then I published to workspace B without an error. Then I made some changes to the report and when I try to publish and replace the report to workspace B I get the error.

[collinq]

Hi @alindquist ,

Yes, there is a setting that doesn't allow for publishing a dataset to another workspace.  This wouldn't affect publishing the report to the original workspace.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!