Can't Publish dataset due to "Refresh in progress" on web!

[More_BI]

Hey guys,

I'm not sure what happened, but my main dataset has been "Refreshing" for two days now and I can't kill the process. I have no idea how to stop/kill the refresh. This is, now, critical because I cannot publish a new dataset.

When I was trying to publish the dataset yesterday, it would just continuously load, load, load, with no timeout/error. Today, I am getting an error stating, "Sorry, you don't have access to publish to this workspace. Please contact the owner for access." This is just not true because I am able to rename this same file and publish it to the same space.

I did some researching on the forums and saw a workaround to rename the dataset and republish; however, this doesn't work because it would erase all of the reports built on web that many of our users are utilizing. 

Can someone PLEASE help me solve this issue?

Thank you,

Albert

[Anonymous]

Hi @More_BI,

>>I'm not sure what happened, but my main dataset has been "Refreshing" for two days now and I can't kill the process. I have no idea how to stop/kill the refresh. This is, now, critical because I cannot publish a new dataset.

This notice will appears when you try to refresh a dataset which is refreshing at the moment. So I'd like to suggest you to refresh it after finish the operation.

>>"Sorry, you don't have access to publish to this workspace. Please contact the owner for access." This is just not true because I am able to rename this same file and publish it to the same space.

It sounds like you are try to publish a report which already exist in the workspace.(report name)

For the install error, can you confirm that you have permission to access the network?

Regard,

Xiaoxin Sheng

[More_BI · Accepted solution]

I should be able to overwrite a dataset while publishing.... in either case, this issue seems to have resolved itself after rebooting the gateway machine again. I noticed the dataset stopped refreshing and successfully refreshed the next morning. Once I saw that, I attempted to publish again and it went through successfully. I don't understand why all of this happened, but Microsoft should provide a way to kill a refresh to prevent this from happening again.

[Anonymous]

Thanks @More_BI for the suggestion, but for us even after rebooting the gateway machine it remains 'in progress',
do you have any other solution .
Thank you in advance.

regards,

Matsa

[More_BI]

I checked the gateway machine and noticed that while the application was running, it was not connected. When I tried to connect, I got the following error:

I'm not sure if this is related to my initial error since I am able to publish other datasets/files to my workspace.