Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Can not refresh the report because of memory of the virtual machine

Hi guys,

 

I have the version power bi report server and my report is connected to a SQL SERVER database which is heberged in a virtual machine. The table in the sql server includes 2 millions lines with fiftieth columns and the report is about 250 Mb.

 

Recently, the report struggles to refresh the data : 

1) the planning of the refresh in the server failed because of memory not enough

2) I tried to refresh the report in Power BI Desktop, once it reached about 1 600 000 lines , it stagnates and resumes a little bit before stagnating again

3) I copied the PIBX in the virtual machine and launch the refresh and check the memory in task manager in the same time. I noticed that when the memory reachs over 90%, the refresh stagnates

 

So I concludes that the problem is du to the lack of memory for the virtual machine . What do you think ? Did you have this one already and do you have a solution ?

 

Thank you very much 🙂 

1 ACCEPTED SOLUTION

Hi, @Anonymous 

It’s hard to find out why there is the error.

Here are some suggestions:

1.Try to use directquery mode instead of import mode if the dataset is too large.

2.Optimize the model to avoid complex queries.

3.Optimize those DAX formulas that have poor performance and may cause very high memory consumption

Related links:

Optimization guide for Power BI

Understanding memory used by Power BI

 

Best Regards,
Community Support Team _ Eason

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi guys,

 

Thank you for your answers

I found the error. It's due to my code M which sort a column for 2 million lines . I removed it and it worked !

collinq
Super User
Super User

Hi @Anonymous ,

 

To answer the initial question - yes, having more RAM and more CPU are good things to allow things to process.  But, when you say it "stagnates" do you just mean that it takes a long time to refresh?  Or, are you saying that it stops?  if it stops, are you getting any error messages?  It also depends if you are "import" or are "Direct Query".  It might also depend on the other things that the SQL server is servicing simultaneously.  It might also be your network speed.  It could be your connection type (VPN, RDP, etc).  it could even be that you have inefficient queries that are causing things to slow down.  Does it eventually refresh?




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Anonymous
Not applicable

Hi

Thank you for answering

by stagnate, I wanted to mean  that it takes a long time to refresh and I used Import mode.

I copied the the pibx into the virtual machine so  could not be my internet speed or VPN and and I had the same problem

 

What kind of queries do you talk about ?

It didn't refresh because it took so much time so I stop the refresh

 

Thank you

Hi, @Anonymous 

It’s hard to find out why there is the error.

Here are some suggestions:

1.Try to use directquery mode instead of import mode if the dataset is too large.

2.Optimize the model to avoid complex queries.

3.Optimize those DAX formulas that have poor performance and may cause very high memory consumption

Related links:

Optimization guide for Power BI

Understanding memory used by Power BI

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors