Hmm, there's one major issue with your set up. Loading that many columns into PQ is going to be very expensive.
When tested on my machine, Memory usage spiked to above 8Gb. That's abnormally high for dataset this size.
Also, speed of query suffers to almost unbearable point. Took about 5 min to load back data with just 3 additional custom columns with unnecessary columns removed...
Let me dissect your workbook and see if there's ways to speed up things.
Bookmarks