I have just upgraded from Excel 2013 Windows 7 to Excel 2016 Windows 10. I have a report in excel that uses Power Query to load in 20 - 30 million records into the excel data model. The report would refresh before I upgraded but now when I try and load the data it comes up with an error message saying 'There isn't enough memory to complete this action. Try using less data or closing other applications. To increase memory availability, consider: - using a 64-bit version of Microsoft Excel. - Adding memory to your device.". My PC has 16gb RAM.
Solved by G. U. in 24 mins