Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Can't save or refresh Dataflow | CdsaObservableUniverseHasChanged and CdsaLockAcquireError

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

 

 

Dataflow
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.