RAM Problems -Excel Crashes even with a very small DataModel

Hi gehe_muc ,

The biggest RAM draw usually comes from SQL SAS and Mashup Evaluations. Therefore, it's possible that your M queries are not efficient in their transformations.

It's difficult to be sure on any of this, but be mindful of using 'whole table' operations, such as pivot/unpivot etc. Also, PQ merges are very expensive, so should be passed off to the data model where possible, or should utilise smart table buffering to avoid multiple calls to a reference table.

You didn't specify how much RAM your machine actually has but, as far as I'm aware, a 32bit app will only use up to 4GB RAM maximum, so you're really going to struggle to use Power Query in any anger in a 32bit Excel file.

Pete