Can't save or refresh Dataflow | CdsaObservableUniverseHasChanged and CdsaLockAcquireError

[Anonymous]

I have two dataflows that normally will take around 45 minutes to finish refreshing; however, I don't know what happened, but it suddenly takes forever today.

I have already tried to cancel the refresh and re-do it again, but still to no avail.

Then I canceled the refresh, opened the dataflow, and clicked save. Now, I cannot even save them!
There are two error messages:

CdsaObservableUniverseHasChanged  
CdsaLockAcquireError

[Anonymous · Accepted solution]

Hi  @Anonymous 

Typically it is slower when using dataflows especially with a lot of transformations because using shared capacity it is sharing the memory and CPU. 

You can consider by separating data ingestion from data transformation dataflows. More info you can refer to the Microsoft offical document below .

Improve performance and reusability by separating data ingestion from data transformation dataflows - Power Query | Microsoft Learn

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

it seems to be the Capacity issue.

I have fixed it by splitting 2 dataflows into 4 dataflows, and now I can refresh and save them.

But let's see other comments if there are other solutions.