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
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - February 2026
Check out the February 2026 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.
