Forum Discussion

HO's avatar
HO
Frequent Visitor
7 years ago

Import data for each row in a parameter table Power Query

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! 

1 Reply