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

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 1
Highlighted
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.

 

Regards,

Cherie

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

Announcements
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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 260 members 2,841 guests
Please welcome our newest community members: