Error Message

[Malps90]

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 

[Anonymous · Accepted solution]

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

[Malps90]

Hi, 

i am currently using 64bit at present and still recieving the same message. 

i am a little lost as to what i need to do to rectify this Error please see image of the error message. 

Many Thanks

[mwegener]

Hi @Malps90 ,

how much memory do you have?

What is your memory usage? (Task manager)

[Malps90]

Hi when the report was applying the query my memory was nearly at its max and my CPU fluctuates between 70% and 90%.

The report is extremely big.

Many thanks

[mwegener]

Hi @Malps90 ,

Do you need the tables with all columns?
How many columns do you have?

[Malps90]

Hi, 

The particular table i am applying ot query too i need all columns and there is only aproximately 10 columns however there is alot of tables in the report and i might be able to reduce this down. 

some of the tables have alot of data in them which have alot of caluclated columns in. 

i have been looking at a way to reduce the coding but not sure if that would help. 

Many Thanks 

[mwegener]

Hi @Malps90 

reduce the model to the required data.
Calculated columns (DAX) are not saved as efficiently as columns calculated in Power Query.

Maybe you can optimize here.

[Malps90]

Thank you

From your experience if i filtered the data out in the query would this help to reduce the intake of the data? or would i need to rediect where its pulling the data from and reduce it there. 

alot of out stuff is pulled from sharepoint due to not having a direct link into our systsems. 

Thanks 

[mwegener]

Hi @Malps90 ,

it should be enough if you filter the query in Power Query.
Filter the data if possible in the first power query steps so that power query can use "query folding" if possible.

[mwegener]

Hi @Malps90 ,

Remove unnecessary columns.

Use the VertiPaq Analyzer to analyze your model.

https://www.youtube.com/watch?v=ERGpV4yt30w

[mwegener]

Hi @Malps90 ,

how much memory do you have?

What is your memory usage? (Task manager)