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

Power Query - Dynamic Parameters to run query

I have developed various templates that are stored in power query connection. I would like the user to select which connection query will be loaded into a table.

 

At this point, I have created a custom function that can load the query based on the selected name. (Code A)The code below only picks up the query to load if it is already loaded into a table in another part of the spreadsheet. I want to be able to load the query if is only in connection. Code B loads the query based on the specific name (connected query). I want input into code by the TemplateType selection criteria to select which query to load. I want code B to do what Coda A is doing. This is probably super easy but I just need the syntex. 

 

TemplateType: this a name range with a drop down of the specific query. 

 

 

Code A: Source = Excel.CurrentWorkbook(){[Name=TemplateType]}[Content]

 

Code B: Source = #"SinglePrice"

1 REPLY 1
Community Support Team
Community Support Team

Re: Power Query - Dynamic Parameters to run query

Hi emoroz,

 

You can use query parameter to switch between data source in power query. You said "I want input into code by the TemplateType selection criteria to select which query to load. I want code B to do what Coda A is doing." , could you provide more details and give some sample to explain more explicitly?

 

Regards,

jimmy Tao

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 246 members 2,724 guests
Please welcome our newest community members: