Forum Discussion
Error Message
Hi All,
i was wondering if sombody could help me i keep reciving the below error message when applying chnages to the query.
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.
MAny thanks
Hi Malps90,
What version of power bi are you test? 32bit or 64bit? AFAIK, 32bit applications have limitations on memory resource usage. I'd like to suggest you switch to 64bit If you are work with 32 versions, it allows you to use more memory resources to calculate.
how much memory can be accessed by a 32 bit machine?
In addition, you can also open task manager to track how much idle memory available. It may also cause the issue if your device does not have enough idle memory resources.BTW, what type of operations you proceed in query editor? Any complex reference/invoke/looping calculation in your query tables? If this is a case, you can consider using buffer functions(List.Buffer, Table.Buffer) to avoid the memory leak of iterate calculations.
How and When to use List & Table Buffer?
Regards,
Xiaoxin Sheng
11 Replies
Hi Malps90,
What version of power bi are you test? 32bit or 64bit? AFAIK, 32bit applications have limitations on memory resource usage. I'd like to suggest you switch to 64bit If you are work with 32 versions, it allows you to use more memory resources to calculate.
how much memory can be accessed by a 32 bit machine?
In addition, you can also open task manager to track how much idle memory available. It may also cause the issue if your device does not have enough idle memory resources.BTW, what type of operations you proceed in query editor? Any complex reference/invoke/looping calculation in your query tables? If this is a case, you can consider using buffer functions(List.Buffer, Table.Buffer) to avoid the memory leak of iterate calculations.
How and When to use List & Table Buffer?
Regards,
Xiaoxin Sheng
Hi Malps90 ,
Remove unnecessary columns.
Use the VertiPaq Analyzer to analyze your model.
https://www.youtube.com/watch?v=ERGpV4yt30w
