Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi folks! I'm facing something weird. I'm trying select rows a table based on a column from another table. I wrote that: Table.SelectRows(#"Colunas Renomeadas", each List.Contains(contas_fDados[Código],[Alternativa Conta]))
The function seems to work, but it never ends. I've already tried with another column and it didn't work.
Any idea?
Thanks in advance!
Solved! Go to Solution.
Hi @rber
Try adding extra step before Table.SelectRows with List.Buffer
step1 = List.Buffer( contas_fDados[Código] ),
step2 = Table.SelectRows( #"Colunas Renomeadas", each List.Contins( step1, [Alternativa Conta] ) )
Hi @rber
Try adding extra step before Table.SelectRows with List.Buffer
step1 = List.Buffer( contas_fDados[Código] ),
step2 = Table.SelectRows( #"Colunas Renomeadas", each List.Contins( step1, [Alternativa Conta] ) )
@Mariusz Great! It worked, thanks a lot. However, I'm still wondering why my method didn't work 🤔
Regards,
Hi @rber
Your method works it's just too heavy on the engine, adding list.buffer loads your list into memory so it's easier and faster to access, other than that your code remains the same.
https://docs.microsoft.com/en-us/powerquery-m/list-buffer
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.