Error when refreshing data in Power BI

[ymy_30]

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! 

[ymy_30]

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. 

[v-shex-msft]

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

[ymy_30]

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

[v-shex-msft]

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

[bajee]

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.

[ymy_30]

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! 

[v-shex-msft]

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