Forum Discussion

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
7 years ago
Solved

Out of memory

 Table2 is a table with unique values of which I need the sum of sales. Table1 contains of 800k rows and Table2 of 130k. I can't slim down the selection of 130k, as it would require me to this over a...
Need Help
  • DouweMeer's avatar
    DouweMeer
    7 years ago

    v-chuncz-msft

     

    Sadly enough I can't test it anymore. I nicked someone else his pc with more memory and expanded the file. My 8GB laptop now can't even open the file anymore because it returns into the error 'out of memory' :). I will add your suggestion to my notes.

zoloturu's avatar
zoloturu
Icon for Memorable Member rankMemorable Member
7 years ago

DouweMeer,

 

Did you try the same calculation but with smaller data volumes? Is it correct one? (you can limit rows amount in PowerQuery) 

 

Please post some sample data for Table1 and Table2. If you can provide a PBIX file then it would be better.

 

Regards,
Ruslan

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
7 years ago

zoloturu

 

Yea, it is supposed to work. I've tested it and the final expression which will use these values given by the expression, gives the correct data. Now as I want to use it on the 'real data', it gives me problems. 

 

As I can't share the real data of course, hereby my test data with dummy values. Also, I can't remove any data by power query. 

 

'Raw data'Rank 2 is unique value for a custom tableAnd the expression used for running total