Forum Discussion
RAM Problems -Excel Crashes even with a very small DataModel
Hi Pete,
I have the FactTable and all the Dimension Tables with relationships in my model, I know this concept.
Indeed it is the second example - I did 4 joins/merge with other information and expand and did filtering with that...
Just now I'm trying to get rid of the concept and I lost already the merges with this concept:
I did some "lookups" with this Add.Column ... each Filialen[VertriebsID]{List.PositionOf(Filialen[FilialID], [Filiale])} and some Filtering with list concept like ... each List.Contains(FEDAS[FEDAS],[FEDAS])
After loosing all my nestedJoin/merge I will test again what happend with Ram 🙂
Thanks!
gehe_muc ,
Yep, this was exactly the kind of thing I was talking about.
I assume that Power Query in Excel also supports query folding so, as long as your fact and reference tables both fully fold back to the server, you should see significant performance gains using these List methods.
If you want to speed it up even further, you can use List.Buffer to buffer your reference lists which will, in the sort term, increase RAM usage, but will release it far quicker, therefore reducing RAM requirement overall.
Pete