cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
petterilaitinen
Regular Visitor

Power BI Desktop freezes at end of loading data from Databricks

Hi.

I have since a week back experienced following issue:

When I update data from existing connection to Databricks, 

I see the table nicely in Power Query editor. Loading starts nicely, and everything goes smooth.

But in the end, when all rows are loaded to the Desktop, the Power BI desktop App freezes.

The below window does not respond, and the only way to proceed is to kill Power BI desktop app using Windows task manager.

Any help or ideas how to go around this?

 

petterilaitinen_0-1651853190344.png

 

 

Specs:

petterilaitinen_1-1651853330330.png

Edition Windows 10 Enterprise
Version 20H2

Processor Intel(R) Core(TM) i5-6300U CPU @ 2.40GHz 2.50 GHz
Installed RAM 16,0 GB 
System type 64-bit operating system, x64-based processor

 

 

2 REPLIES 2
v-yangliu-msft
Community Support
Community Support

Hi  @petterilaitinen ,

Here is a newly released Power BI Desktop, could you please try with it? Here’s the link of latest version of Power BI Desktop: Download Microsoft Power BI Desktop from Official Microsoft Download Center.

In addition, we have seen some frozen issues recently and here is a workaround you can try as well. Please try it and let me know whether it is applicable to you. Thanks in advance!

Go to File>Options and Settings>Options>Preview features> Untick Power BI Desktop infrastructure update

vyangliumsft_0-1652060803591.png

Or You can try to set 'Load Tables simultaneously', Maximum allowed and clear the cache of Power BI Desktop in Options and settings to check it again.

vyangliumsft_1-1652060803595.png

In addition, If there are multiple threads in the background, consider reducing some to check whether this could be mitigated.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks @v-yangliu-msft !
I installed the new version that you linked above. And tested updating the data in the Power BI file. Consequence: Same behaviour, it froze at end of load.

I also ticked off Power BI Desktop infrastructure update, and cleared cache and tested higher values for 'Load Tables simultaneously'. Restarted the Power BI desktop app thereafter and tested again. Same consequence: full freeze at end of load.

I also tried changing report spefific settings, but with the same consequence. It just freezes at the end of the load.

 

Br., Petteri

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors