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 wit...
Need Help
XchangeVisions's avatar
XchangeVisions
Frequent Visitor
4 years ago

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
4 years ago

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 ::

 

 

  • XchangeVisions's avatar
    XchangeVisions
    Frequent Visitor
    4 years ago

    Hi collinq 

     

    Thanks for your reply.

    However, it's is not helping me as I know the difference between a report and dataset.

    Hence I find it a bit lame that you plug your own irrelevant blog post to this question.

     

    I just want to know if and how I can fix the cloud refresh error when publishing.

    • steveplatz2's avatar
      steveplatz2
      Frequent Visitor
      4 years ago

      XchangeVisions 
      Were you able to find a solution to your issue? I'm running up against the same problem. I'd like to stop using cloud refresh and just publish directly to the workspace, but can't find a way to disable it on the PBI service side. 

      • XchangeVisions's avatar
        XchangeVisions
        Frequent Visitor
        4 years ago

        steveplatz2 

        Nope, I'm still not able to disable it and publish directly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      FWIW, it was quite clear to me that you understood this in detail. I have also tried using the REST API (Reports - Update Report Content In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn) to attempt to update such a report to no avail. Very frustrating problem. I wish I could just disable the cloud refresh configuration or force an overwrite. As it stands, there's just no way to update reports with this configuration. 😞 

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Actually, I just had success with this method. I was able to update thin reports that I could not previously update by publishing directly from Desktop. This did not break the connection with cloud refresh, but it did allow me to update the report content. 

         

        This does require publishing the report to a different location to be able to serve as the source file. But the REST API could be configured to upload the file from a local PBIX, perform the update and then delete the local PBIX, if you don't want a staging workspace. A definite workaround, but surprised this worked at all.