Forum Discussion
RAM Problems -Excel Crashes even with a very small DataModel
Hi to all! I'm working with Win 64bit, Office/Excel 365 Desktop with 32bit. Using PQ, PPivot, DaxMeasures an Excel-Tables. I developed a small Data Model with 6-8 tables, some relationsships and th...
Hi Pete,
as I told before it's difficult to change to 64bit, because my customers have 32bit and the solution is for my customers... I will first try to find other ways.
I tried a workaround now: I'm loading the main fact table from SQL in an Excel workbook separetly and in the Main application I'm loading from this Excel-Workbook. Now its a bit more stable and the Workbook mostly uses betwenn 800 MB and 1,2 GB RAM.
But am interested to learn more about efficient transformation.