Locking Conflicts Error Message

Anonymous · ‎03-11-2020

Hi

When i run my Power BI, i face the issue of unable to load data due the operation being cancelled because of locking conflicts.

Kindly advise on what can i do about this.

Thanks.

JElieson · ‎07-12-2023

It's basically an error because you're desktop is running too much at the same time. Think limited RAM. Close down some of your other open files, maybe restart your computer, but that should do it.

v-chuncz-msft · ‎03-17-2020

@Anonymous

You may take a look at Analyze Deadlocks with SQL Server Profiler.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler · ‎03-11-2020

Oooh, nifty, never seen that. Import, Live or Direct Query?

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎03-11-2020

Import Query i believe.

Greg_Deckler · ‎03-11-2020

Surprising, I would not have guessed that. What verion of the Desktop?

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎03-11-2020

Windows 10 Enterprise

Greg_Deckler · ‎03-12-2020

Sorry, Power BI Desktop. File | Options and settings | Options and the Diagnostics.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...