I am getting the following error while refreshing data

[PavaraTM]

Hi,
My data souce is a MySQL database and I am using a view to retreave data to the Power BI desktop. My refresh is failing due to the following error. Is there any solutions for it or it is what is it is with the Power BI limitations?

Failed to save modifications to the server. Error returned: 'There's not enough memory to complete this operation. Please try again later when there may be more memory available.

[PaulShlapa]

I have had a 32-bit version of PowerBi installed on my 64-bit computer. Installing a 64-bit PowerBI version solved the problem

[Idrissshatila]

Hello @PavaraTM ,

What I also would add is that, try refreshing each table alone from power query to check if they're all getting data normally withouit any error in this phase.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Idrissshatila]

Hello @PavaraTM ,

If you're trying to load a huge dataset, try removing columns that you don't need or also you could filter columns to get what you need.

also, check this discussion on the same case you have https://community.powerbi.com/t5/Desktop/There-s-Not-Enough-Memory-To-Complete-This-Operation/td-p/3...

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin