Slow refresh

[mr2bart]

Hi,

I am beginning in power Query in Excel.
I have a general issue is the speed of refresh. I have something very basic code like :

    Source1 = Excel.CurrentWorkbook(){[Name="tblprofit"]}[Content],
    #"Filtered Rows1" = Table.SelectRows(Source1, each ([Sales organisation] <> null) and ([Import] = "X")),

to get Source1 which is a small table of 50 lines and 6 columns, sometimes it is immediate, sometimes it take 2-3 minutes, even more to get the refreshed data list.

I have a new labtop i7 64bit, 16GoRAM, should be enough! Is there some Excel/Windows options to fine tuned ? Did I miss something?

Thanks!

 

[sandy666]

no comments
you are welcome

 

[mr2bart]

Hi all,

Got it now. In Query option -> Data load -> Background data -> "Allow data preview to download in background". I have un-ticked this option. Now speed is OK!

 

[sandy666]

it should be off by default, but maybe I am wrong
good you found it