Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @FrancescoQuara ,
I found some similar posts which might be helpful to solve your issue:
Transaction (Process ID 83) was deadlocked RSS
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.
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.
Hi @FrancescoQuara ,
I found some similar posts which might be helpful to solve your issue:
Transaction (Process ID 83) was deadlocked RSS
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.