Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
I'm getting the below error recently, last month i got this error, but the next day it is working, this month i'm attmepting for various days still no luck - Please advise on the tips and solution to solve the same, My data is having more than 2.2 Mio line items with various 9 excel files.
Thanks for the response, Memory constraint loaded via - gateway and working fine.
Hi @Balajisankar ,
You should be using variables(Var) for storing results in case of complex calculations
such that you do not run out of memory. Also note that Power BI is a visualization tool, (it is not excel, yet many people think power Bi can be used/replace excel for reporting instead of excel). Before I can tell anything further..I have few questions for you..
1. How many measures are you using (i.e. columns with calculator sign on them)?
2. How many columns do you have? (Please ensure that you have only necessary columns, delete those columns that are not necessary)
3. Are all the calculations (measures) being calculated concurrently?
4. Is there a possibility of taking calculations to a backend such as Excel or SQL-server?
Also. there are some tips about managing Memory, you can review them in this similar thread.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Balajisankar , Increase memory management cache ( 8 GB to 10 GB), supported by RAM and virtual RAM in your system. make sure you have sufficient hard disk space, and then try. If that does not work, try removing some complex DAX calculated column, if any
Thanks for your response, however i still have the same issue, i'm using 16 GB Ram, 64 Bit Operating system, Windows 10, its three years of data - need further advise in this matter.
Just to add, i have done the above setup as suggested - FYI.
Thanks Guys, No, nothing in date columns, memory constraint loaded via - gateway and working fine.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |