Forum Discussion
Solved
Filtering performance within power query referencing dataflow
Hello We have worked around this for now but I would appreciate a greater understanding of the performance issue we found We have two dataflows that each create a table based on a folder conn...
Please share the M code from your #3 scenario. I suspect you could use List.Buffer or Table.Buffer to load your meta file contents only one time to be used in your Dataflow filter.
Pat
Please share the M code from your #3 scenario. I suspect you could use List.Buffer or Table.Buffer to load your meta file contents only one time to be used in your Dataflow filter.
Pat
List.Buffer does the trick. Thank you.
Now you've said that I can find loads of posts with this detail on but couldn't see for looking before!