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!
