Forum Discussion
Publish dataset error - set up with cloud refresh
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.