Forum Discussion

XchangeVisions's avatar
XchangeVisions
Frequent Visitor
4 years ago

Publish dataset error - set up with cloud refresh

I get an error while trying to publish dataset from desktop to workspace.

The error states: "A dataset or report named xxx already exists and is set up with cloud refresh. You can save this file with different name and publish again'.

I've disable 'OneDrive refresh' on the Settings page for the existing dataset but it still throws the error.

Is there a way to disable the cloud refresh (remove/disable the 'OneDrive refresh') and publish from Desktop?

 

It's not a solution to delete the existing dataset and re-publish from desktop, as this will break everything that uses this dataset.

 

13 Replies

  • sebadb9's avatar
    sebadb9
    Kudo Collector

    I have the same issue. Deleting and republishing is not an option, I'll lose all comments in all related reports to that dataset, I'll have to reconfigure many things like security, many other applications have deep URL links to that reports on that dataset etc...

    Is there any way? Has anyone raised a support ticket for this?

    The OneDrive refresh toggle is turned off as far as I know:

     



  • Hi XchangeVisions ,

     

    This is not related to OneDrive.  What this means is that the DATASET name is already in that specific workspace.  Basically, you can't overwrite the name.  If you are unsure look at the workspace itself and look at all of the datasets and see the one that is the same in that workspace.  If you don't want a duplicate, either rename the one in the dataset or the one in desktop and then republish.

    • XchangeVisions's avatar
      XchangeVisions
      Frequent Visitor

      Thanks for your response.

      I downloaded the pbix from the workspace, did some updates and then tried to publish.

      So it should just overwrite the existing dataset with the updated version right?

      I just want to publish from Desktop and not upload to the OneDrive anymore and wait for it to replace the workspace version.

      I figured the Dataset was initially configured using the cloud sync (by someone who left the company) but it looks like I'm not able to change that?

      • collinq's avatar
        collinq
        Super User

        Hi XchangeVisions ,

         

        It appears that you do want to overwrite since you brought it down, modified it and want the new version to be available.  When you publish the file, then it is in Power BI Service and available there and should be used rather than a .pbix file in OneDrive.

         

        You can change the datasource for your report if that data is in OneDrive.  There are two aspects here, the data is coming from a location (perhaps OneDrive, perhaps elsewhere) and the report itself is a file that is accessed by the users to see the dataset.  This article might be helpful in breaking down the differences between dataset and report.

        Power BI – Apps, Workspaces, Dashboards, Reports and Datasets Defined : :: Welcome To EPM Strategy ::

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    +1 on this issue. I have thin reports that were connected to PBIX files in OneDrive, but that sync no longer works. If I want to make an update to the report, my only option has been to republish a new report. This isn't the worst situation, as these reports are published within apps, but it does stand to break any user bookmarks since it is technically a new report. 

     

    I tried editing the report in the PowerBI service directly, hoping this would "break" the cloud refresh and store the PBIX there, but it still generates the error.