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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

thank you for this reply.

 

This is exactly what I was thinking about in first place and was looking for option where you can set order for tables to load.

 

Apparently this option was turned on all the time. Shouldn't I turn it off instead, to prevent table C (created in the query editor) from loading while tables A and B are not fully loaded yet?

 

As mentioned above, IT guy said "We are aware of the problem and this is because we have some issues on server". I know this can be one from many resons why it is deadlocking though.

 

thanks

 

daniel

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous,

How your database connections configured? Is that device running with a heavy workload? If they did not exist enough ideal connection session resources, the parallel loading feature also not works for this scenario.

Regards,

Xiaoxin Sheng