Hi, I need to do a lookup in Power Query. I find that every time I merge tables, that query struggles even more to refresh.
I found the below formula on the Power BI website, but it also seems to struggle to refresh.
let materialgroup = [Material number] in Table.SelectRows(MARA, each [Material number] = materialgroup)){0}[Material group])
Is there any other way I can pull info into a Power Query table from another table, not using Merge?
Thanks
Vicky
Hi Vicky,
There aren't any other ways to merge that I know of.
This post offers some suggestions on improving Power Query refresh times.
Mynda
Hi Vicky,
You can use List functions rather than merging. You may need to use List.Buffer() to get the best performance.
https://www.myonlinetraininghub.com/vlookup-using-dates-in-power-query-using-list-functions
Regards
Phil
