Please increase dataset limit of Power Query from current 256MB
I think currently power query starts paging when the size of dataset is more than 256MB. I want to analyze 5 years of data, but as the size of dataset that gets close to or more than 256 MB then power query becomes extremely slow. 1 reach dataset limit of 256MB with just 1 year of data.
The link below also says how power query slows down when it reaches 256MB dataset limit
Power Query has been an extremely useful tool in automating data cleaning/shaping/transforming. However, when I approach near 256MB it becomes extremely slow. If I add just 1 step when power query is near it's 256MB limit then it would take about 30 mins.
Yehoshua Coren commented