locked
Power Pivot Errors (Jquery and out of memory) RRS feed

  • Question

  • Hi,

    I having some issues with PowerQuery and PowerPivot for Excel 2013. I make a odata connection to CRM online. And select 3 entities. Contact account and opportunity. The time it's takes to get all the data is a lot, but acceptable. The machine uses all the CPU and harddisk resource but the data is loaded.

    The problems start when I select PowerPivot window and in the tab select manage data. The data is loaded on the screen. But when I click Diagramview Excel stops working and I get a KeyCode error.

    I am using Excel 2013 32 bit. I got an i5 2.60 ghz with 16gb of memory. I think this should be enough.

    What I would like to know what are the recommended systemsettings for the use of PowerQuery en PowerPivot. And is there a solution for my problems with the diagramview.

    Regards,

    Dennis


    • Edited by Dennis Lutjohann Saturday, November 29, 2014 12:18 PM
    • Moved by Curt Hagenlocher Sunday, November 30, 2014 1:30 PM Seems more like a Power Pivot issue than a Power Query one
    Saturday, November 29, 2014 12:17 PM

Answers

  • Excel 32 bit can only take advantage of 2Gb of RAM in the best of the scenarios. For me it couldn't go above 700mb when using Power Pivot.

    I would strongly suggest go to 64 bits in both operating System and Excel.

    Hope it helps

    Wednesday, January 7, 2015 7:05 PM

All replies