Showing results for 
Search instead for 
Did you mean: 
HO Frequent Visitor
Frequent Visitor

Import data for each row in a parameter table Power Query



I'm trying to import data to Power BI via url where the url have two parameters - arg1 and arg2. I have a table Args with columns arg1 and arg2 and I want to retrieve data for each row in Args. I have written a function, DataFunction(arg1,arg2), that given arg1 and arg2 returns a table in the required format. The next step is to loop through all rows in Args and append the table. My code thus far looks like this:


Source1 = DataFunction(arg12, arg12),
Source2 = DataFunction(arg21, arg22),
Source = Table.Combine({Source1, Source2 })


In stead of arg11, arg12, arg21 and arg22 that in my case is hard coded, I want a generic method to combine all tables that corresponds to a row in Args. 


I have experimentet a bit with the each statement, but I have not yet figured out how to make it work. This should just be a simple loop, but it appears to me that Power Query don't support this. 


Any help is appreciated! 

v-cherch-msft Super Contributor
Super Contributor

Re: Import data for each row in a parameter table Power Query

Hi @HO


I'm afraid i cannot fully understand it. Could you show us a simplified sample like this post? You may also get further help from Power Query Forums if you post the issue.




Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 44 members 1,204 guests
Please welcome our newest community members: