Not Enough Memory Space

[LinlookZDJ]

Dear Power BI Experts,

I have came across a very weird situation. 

Before I adding the last column in my data table - "TimeGap", I can load up to 300 + raw files within a short period of time.

However, after I added the "TimeGap" column in my data table, I can't even load up to 7 raw files and the error appeared as follow:

May I check is my custom column added too complicated or due to other reasons? (Attached my sample raw file and Power BI desktop for your reference)

https://drive.google.com/drive/folders/1J7vmtYcmUosf6APrz5H2IK_PjoVjnRZy?usp=sharing

Appreciate and welcome any recommendation or suggestion.

Thank you for your time!

Best regards

Lin

[Anonymous · Accepted solution]

Hi @LinlookZDJ 

Due to I don't have access to your data source, I couldn't do some research in Power Query.

Here I will give you some advice.

1. 

Please try to turn off the 'relationship detect' options to disable auto detect the table relationships.

For reference: Create and manage relationships in Power BI Desktop 

2.

I see there are some date type column in your Sample. In the Options and setting disable Auto Date time option ,

Increase Cache. File -> Options & setting -> Option -> Data load

Increase virtual memory of the system. Sometimes C drive does not have enough space to expand. if you other drive add Virtual memory there.

Refer to these setting: https://www.thebiccountant.com/speedperformance-aspects/

3. 

How many records are your data table hosted? Any complex expressions calculation(multiple iterators, nested cross table looping calculation ....) and advanced operation(merge, combine, reference, invoke custom functions, recursion...) existed in Dax or query editor side?

For reference:

Optimizing nested iterators in DAX 

Recursive Functions in Power BI / Power Query 

They may affect the performance and spend a huge amount of system resources.

You can also take a look at the following document about performance tips:

For reference: Optimization guide for Power BI 

4. You can try to use Query Diagnostics or Performance Analyzer to monitor your Power BI performance.

For reference: Monitor report performance in Power BI

5. Please download the latest Power BI Desktop version and try again.

Download by this link: Link

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.