Forum Discussion
Publish dataset error - set up with cloud refresh
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.
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.
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.Nope, I'm still not able to disable it and publish directly.
I found a "workaround" for my situation, but it might not be valid in yours.
My workspace was part of a deployment pipeline. The datasets and reports with cloud refresh were all published in the dev workspace. When that workspace was pushed to test, power bi removed cloud refresh, since the data is local to the workspace.
What I did was:
1. Publish all changes to test workspace
2. Removed everything from the dev workspace
3. Used the "Deploy to previous stage" feature of the pipeline to copy everything back to dev and maintain the connections to the reports and datasets in test
I could not find a way to disable cloud refresh otherwise.
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. 😞
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.
