Publish or update dataset online

[josevieira]

Hello,

Today I came accross with the next situation

error column ID in Table contains a duplicate value 9999 and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table

The info that is the source of the error is within a dataflow and I delete de record and datset is not refreshing.

Download dataset to perform improvements and try to publish. the loading windows seems like in a infinity loading and does no finish the publish action.
Then I try to force the update of the dataset and does not refresh at all.

anyone can help?!

Thank you

[v-yangliu-msft]

Hi  @josevieira ,

This is the related document, you can view this content:

Dataset refresh cancellation is now available in Power BI Premium | Microsoft Power BI Blog | Micros...

Re: How to stop manually a scheduled refresh on Po... - Microsoft Power BI Community

Solved: How to cancel refresh - Page 2 - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[josevieira]

I try to access Security of dataset and return:

there is any way to force and cancel refresh?
at current moment i not have any file publishing or refreshing the dataset.