Forum Discussion
How to Loop through Systems and Append?
Thank you in advance I'm new to power query so any guidance is greatly appreciated. I typically create a connection and query for each system but now as I have 100+ systems and will need to be a...
Hey!
You can parametrize some of the logic inside your query and then convert your query into a function and use it as reusable piece of logic.
Below is the official documentation on how to create a custom function in Power Query:
Using custom functions in Power Query - Power Query | Microsoft Docs
Hope this helps!
Each System has an identical table structure. It's just different locations