How to prevent a refreshing Dataflow to get into a deadlock

[FrancescoQuara]

Occasionally the following error (with the message below retrieved from the Web UI) prevents a PowerBI Dataflow to refresh successfully. The Dataflow is running in a Workspace backed by Premium Capacity and it is built from a linked entity.

Error: Data Source Error : DataSource.Error: Microsoft SQL: Transaction (Process ID 83) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. DataSourceKind = SQL DataSourcePath = .\cdsasqlcache

Are there any recommendations on how to prevent this from happening or any guidelines on how to troubleshoot the issue?

[cvillegas]

Hi @FrancescoQuara did anyone ever get you a response with an answer to this? We're encountering this as well when we leverage the Enhanced Compute engine and create seperate dataflows that call one another.

[v-stephen-msft · Accepted solution]

Hi @FrancescoQuara ,

I found some similar posts which might be helpful to solve your issue:

Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen a...

Transaction (Process ID 83) was deadlocked RSS

Error: ‘Transaction (Process ID 83) was deadlocked on lock resources with another process and has be...

Transaction (Process ID 83) was deadlocked

Best Regards,

Stephen Tao

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