Forum Discussion
Power Query Editor Steps are painfully slow
I am using power query editor in power bi with many (like 30) different queries. Now every step in a query takes literally ages to load in preview. Even If I go on the very first query step, which ...
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.
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]))