Forum Discussion
Power Query Editor Steps are painfully slow
Uncheck all the settings where Power Query tries to mess with the meta data (column type inference, relationship detection etc.) Uncheck anything you don't want Power Query to do for you.
I am running a import using get from folder and it has MANY files to bring in. They are global files and I need to bring down to my specific lines to import. I created a filter using the below syntax where ETF_List is the list that I want to use to filter down where the Symbols match.
My issue is using this is EXTREMELY slow. Is there way to speed this up?
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each (List.Contains(ETF_List,[Symbol]) = true))
Use List.Buffer on your list, and experiment with indexing the [Symbol] column, or using Table.Buffer on the files once they are read into tables.
lbendlin what would that syntax be? I am new to power queries.
LB = List.Buffer(ETF_List),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each List.Contains(LB,[Symbol]))