Hello team,
I have a table with 1120920 records, but it receives data every time I run the query so it is real-time data. The problem I face is when I refresh the dashboard in the afternoon or morning I get the error message below. Now my question is the error due to real-time data? or something else.
I use the import mode to connect between the dashboard and the database.
You have a ton of records so your queries require a lot of memory/resources for them to be updated. Since you are connected to a database, someone/something else is also consuming from the database. This causes for your source to not be able to attend all requests and decides to shut down yours.
Check if this page gives you more insight https://sqlbak.com/academy/transaction-process-id-was-deadlocked-on-lock-resources-with-another-proc...
Did I answer your question? Give your kudos and mark my post as a solution!
Proud to be a Super User!
You have a ton of records so your queries require a lot of memory/resources for them to be updated. Since you are connected to a database, someone/something else is also consuming from the database. This causes for your source to not be able to attend all requests and decides to shut down yours.
Check if this page gives you more insight https://sqlbak.com/academy/transaction-process-id-was-deadlocked-on-lock-resources-with-another-proc...
Did I answer your question? Give your kudos and mark my post as a solution!
Proud to be a Super User!
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
