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!
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?
Based on error message, it told you 'not enough memory to complete the operation'. How many Idle RAM available on your device and server?
Hi @v-shex-msft , thank you for your reply.
My device have 8GB RAM. Should be enough to run the operation right?
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)
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" .
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.
We are excited to announce the Power BI Super Users!
Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.