POWER QUERY Loading VERY SLOWLY

[shane_aldrich]

Hi All,

I have several reports that have this issue. Recently lease rolled and had office 365 64Bit before and after, but something is just different. All of my queries are absolutely crawling now (I am reading various file types: (CSV, .XLSX & .TXT), it doesn't matter if I run it on that local desktop, or pull in data from my laptop.

I changed my setting to fast load...

I've read about buffering / folding and to be honest it's a little beyond me.

Some of the files are large, 200K rows * 100 Column, but it never used to be an issue getting desperate...

Is there a setting I'm possible missing, or can I alter my query to improve performance somehow?

Thanks,

Shane

 

[Matt Allington]

When you say you changed to fast load, do you mean this? https://blog.crossjoin.co.uk/2016/1...preview-to-download-in-the-background-option/

if not, try turning off background refresh