cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

There is not enough memory to complete this operation

Dear, Everyone
I am beginner of Power BI I really need help from other people has experience  with my issue. I have total records in a table 20 Millions rows. 

Step:
1. I convert multiple currencies to only USD(0.USD_CR_AMT)
2. I find average credit_amount by total sum(0.USD_CR_AMT)/count(credit_amount)
Final, What i need:
3.I want category all average credit_amount(from 2nd step) into group:$300 - 1000$,  $1000$- $2000,etc
First attempt, I use 3rd step in column(Error occurred like image below).
Second attempt. I use 3rd step in measure (Error occurred the same like image below).

Please, someone suggest any idea or good solutions to me

thank in advanced.

 

ErrorMemory.jpg

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi khihortmrm,

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 powerbi 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 calculation to backend such as Excel or SQL-server?

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi khihortmrm,

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 powerbi 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 calculation to backend such as Excel or SQL-server?

 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.