Forum Discussion
Not Enough Memory Space
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
Hi Anonymous
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.