cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

changing a parameter value in a query step

I have created a PowerBI template that takes two (text) parameters.  Upon opening the template the parameters are prompted for by the system and entered by the user.  This works as required.  As the various other queries in the template are executed, is it possible to include as a step in one of these queries a command to modify one of the parameter values so that futher processing can use the new value for the parameter?

 

Additionally:

 

- is it possible to delete a parameter in a query step?

- is it possible to create a parameter in a query step?

 

 

2 REPLIES 2
Anonymous
Not applicable

Unfortunately no.  Parameters are defined once and then are unchanged throughout the execution of queries at runtime.

I have some difficulties understanding what you are trying to do and what you mean with a "template".

 

Anyhow, if you have a parameter defined in Power Query like:

 

Changing parameters in Power Query.png

Then you can perfectly have query code (or a function parameter) with the same name "Parameter1" and another value, like:

 

let
    Source = #table(1,{{1}}),
    Parameter1 = "John",
    Custom1 = Parameter1
in
    Custom1

Actually, when reading multiple files from a folder, various query objects are automatically created, including a parameter that points to the example file and used in the example query, while the corresponding function has a parameter with the same name, overriding the parameter value that points to the example file.

 

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors