Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI Deadlock, no issues while ran on SSMS

Hi all, I am having Deadlocks issues while refreshing data in PBI Desktop. The problem occurs only from time to time and If I'll try to refresh one again sometimes it works. There are no problems wh...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous  are you doing reads with (nolock) in your sql?   If not i suggest you do uncommited reads as its possible the tables are updating or there is a table lock on them while you trying to pull down the data.  

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Vanessa,

 

I don't really want to use NOLOCK as this may cause some issues with numbers. Although, your post forced me to go to IT guys and ask them about it and they said its something with server itself and they are working on fixing it.

 

I'll give you point as your reply really helped with getting to the point where I am satisfied.

 

thanks

 

daniel