- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Error: Transaction was deadlocked on lock
Hello, since a few days ago, I have been getting the error message above for different transactions.
Through my research so far, I've roughly understood what a deadlock is, but I don't understand what I as a Power BI user can do to fix it.
The error has been appearing on even the simplest transactions. For example:
1. In Power BI Desktop, I connected to a SQL database through Direct Query and loaded two tables. I tried to display them as tables in Power BI and got the deadlock error message for one of the tables. For the other table, it worked but loading the different columns took a few minutes at least. This is something that always worked without an issue, before.
2. I tried create a dataflow by first transforming some tables in Power Query that I also loaded from the same database. At first, the loading time was significantly longer than before. At some point in the transforming process, I always got the deadlock error message.
To my understanding, this has to do with the interaction between the database and Power BI. How do I approach a possible solution for this problem?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Talk to the DBA and see if you are the issue (too many queries) or they are the issue (too much pessimistic locking)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Talk to the DBA and see if you are the issue (too many queries) or they are the issue (too much pessimistic locking)

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-16-2024 06:09 PM | |||
12-05-2024 03:11 AM | |||
06-25-2024 10:25 AM | |||
12-06-2024 02:35 PM | |||
01-08-2025 04:27 AM |
User | Count |
---|---|
138 | |
107 | |
84 | |
60 | |
46 |