User Input Parameters in Power Query

[dpareek]

Hey All,

I am running multiple stored procedures from the Power BI desktop on the SQL server. Using the query editor, I am passing parameters defined by me to the SQL server.

All of the stored procedures/queries take ProductID1 and ProductID2 as parameters.

I am not sure how to make this parameter accessible to a user once I publish this report.

Please suggest.

Thanks!

[pvuppala]

I'm looking for the same except my parameter is the source database name, not sure if its possible but trying to give user an option to choose "Test" or "PRod" server as source to show some metrics.  I can select it in the Transform editor but it would be great if this can be a toggle or some input from the user.