- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, please consider accept as solution to help other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, please consider accept as solution to help other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-23-2024 09:19 AM | |||
05-28-2024 12:45 PM | |||
11-29-2023 02:26 AM | |||
Anonymous
| 01-08-2024 06:12 PM | ||
09-12-2023 09:02 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |