Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

jbillard

New Desktop version hanging on connecting to model

Submitted by on ‎09-29-2022 09:16 AM

jbillard_1-1664467940646.png

This version of PowerBI Desktop has caused one of our files to hang on refresh.  I've seen this issue mentioned in previous versions.  Is anyone aware of this bug and are there any solutions to this?  The file refreshed fine last week.

Status: Needs Info

Hi @jbillard ,

 

Will it eventually generate any error messages, or does it always remain in such a refreshed interface?

 

Is this the only file you encounter this problem with, or does it happen with every single one?

 

Best regards,

Community Support Team Selina zhu

See more ideas labeled with:
5 Comments (5 New)
Comments
v-mengzhu-msft
Community Support
Community Support
‎09-29-2022 07:23 PM
Status changed to: Needs Info

Hi @jbillard ,

 

Will it eventually generate any error messages, or does it always remain in such a refreshed interface?

 

Is this the only file you encounter this problem with, or does it happen with every single one?

 

Best regards,

Community Support Team Selina zhu

jbillard
Regular Visitor
‎09-30-2022 09:17 AM

@v-mengzhu-msft At one point it did which was a null type to text error.  I fixed that error and it still hangs.  I installed the August version of PowerBI and no difference.  It is only one file that has this issue and it only began happening this week.  The data sources are all excel documents using a Web connection to our SharePoint site.

v-mengzhu-msft
Community Support
Community Support
‎10-03-2022 12:45 AM

Hi @jbillard ,

 

Is there a detailed error message, or can you show a screenshot related to the problem?

 

Best regards,

Community Support Team Selina zhu

jbillard
Regular Visitor
‎10-03-2022 06:05 PM

The error below after a few hours is produced once my RAM (16GB) runs out.  The culprit is the SSAS process which I've monitored in task manager.  It steadily grows until the eventual crash while all other subprocesses stay relatively unchanged.  The document is not large enough to warrant such high RAM usage.  I've checked DAX studio for any high cardinalities and heavy memory loads but nothing stands out.

 

"Failed to save modifications to the server. Error returned: 'There's not enough memory to complete this operation. Please try again later when there may be more memory available."

v-mengzhu-msft
Community Support
Community Support
‎10-04-2022 01:56 AM

Hi @jbillard ,

 

Thank you for the information you have provided.

It seems very likely that the problem is caused by a lack of memory. If you can, you should reduce the amount of queries in the file as much as possible to improve the file's runtime performance.

 

Hope this link can help you:

How to Improve Power BI Performance - Part I (bluegranite.com)

Monitor report performance in Power BI - Power BI | Microsoft Learn

 

Best regards,

Community Support Team Selina zhu

Idea Statuses