Running out of Memory for larger date range

[sovereignauto]

Afternoon, 

I have a report with 10-15 tables most work no problem, i have one table that when i change the date range from 3 month to anything beyond 6 months it gives me the "not enough memory" error.

looking if someone could point me in the right direction to identify what is causing this table to have the issues, im guessing one of my DAX but there are a few so ideally need to find out which one then i can try to make more efficant. 

I do have two DAX SUMMARIZE tables linked to it, not sure if this matters

Any help would be appreciated! 

[v-yingjl]

Hi @sovereignauto ,

If your data soucre supports direct query mode, you can use direct query mode to connect.

Please refer: About using DirectQuery in Power BI 

In addition, you can follow these articels to try to optimize your data model which could help you:

1. Optimize a model for performance in Power BI  
2. Optimization guide for Power BI 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@sovereignauto , In the option and setting increase the cache memory .

Also increase system's virtual memory

https://windowsreport.com/memory-error-allocation-failure/

Share the measure taking to much of memory

[sovereignauto]

HI @amitchandak thanks for this, done both them things! 

not sure what to try next! its only 70k rows with 40 columns