Import data for each row in a parameter table Power Query

[HO]

Hello,

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:

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

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]

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.

Regards,

Cherie