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

Error when refreshing data in Power BI

Hello All, 

 

need help in telling me what is wrong . Could not seem to refresh data into my old Power BI report. However, when I import data from SQL Server into a newly Power BI report, it seems fine, and run perfectly. 

 

Your help would be appreciated! Thank you! 

 

error.PNG

 

7 REPLIES 7
Frequent Visitor

HI @v-shex-msft , 

 

My power bi dekstop is x64 bit ya. It still have the error when i refreshed the data. Can the sql server caused this problem to occur?

 

Thank you. 

Hi @ymy_30,

 

Based on error message, it told you 'not enough memory to complete the operation'. How many Idle RAM available on your device and server?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi @v-shex-msft , thank you for your reply. 

 

My device have 8GB RAM. Should be enough to run the operation right?

 

Best regards, 

Mun Yee

HI @ymy_30,

 

I think you need to check on resource manage if other applications spend huge of memory resources.(idle memory not enough to complete power bi refresh operation)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Resolver III
Resolver III

Hi,

 

What is your Data Source and How your refreshing in your reports.

 

Can you please explain in detail. So that we can help you

 

Regards,

Bajee.

Frequent Visitor

Hi Bajee, 

 

My data source is from the SQL Server ya. I have some new data that i would like to import from SQL Server to my Power BI report. Normally, I will just click on the refresh button, then it will refresh. 

However, the error came up, by saying "there's not enough memory to run this operation" . 

 

Thank you! 

HI @ymy_30,

 

Which version of power bi desktop you used?(32 bit or 64 bit)

 

I'd like to suggest you use 64 bit, it can support more processing memory than 32 bit.

Chat Question: Memory Limits for 32-bit and 64-bit processes

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors