Power BI error - 'Theres not enough memory to complete this operation' error.

[Souj]

I am trying to run a power BI report at my office in Power BI desktop and unable to apply the changes as the system throws a 'Theres not enough memory to complete this operation' error. I have tried a couple of things:

Increased the memory in settings

reduce the queries to use just one file instead of a folder.

The queries mainly retrieve the latest file from folders in shared drive.

Can you please help me wit this issue!

Thank

[Souj]

@Ibendlin, There are 2 types of queries: One, The query us designed to pick up the most recent file from the mothly folder. The month is manually changed. Second, the data source is a mailbox and data is taken from the mailbox. In the first case, I am unable to select the recent file directly at the source as pwer query only selects folders and not files. 

[lbendlin]

Can't help you if you can't show a sanitized version of the queries.

[Sahir_Maharaj]

Hello @Souj,

1. Consider filtering data at the source if possible. If you're using Power Query to transform data, some transformations are more memory-intensive than others. Combining files, especially using the 'Folder' option, can be resource-heavy.

2. In the Options dialog, under "Data Load", you can turn off the "Auto date/time" option. This can sometimes improve performance. 

3. Under the Options dialog, navigate to "DirectQuery" and consider increasing the timeout value

This might be able to assist you: https://community.fabric.microsoft.com/t5/Desktop/Not-enough-memory-to-complete-this-operation/m-p/3...

Should you require any further assistance, please do not hesitate to reach out to me.

[Souj]

@ Sahir

I tried unchekcing Auto Date/Time option but to no avail. I couldnt find this option: navigate to "DirectQuery" and consider increasing the timeout value in my power BI file.

[lbendlin]

These issues are usually caused by misguided attempts at merging data sources in Power Query.  If you only ingest these files and append them you won't see the issue.

Can you post a sanitized version of the Power Query code?