Dynamic Power BI reports using Parameters

[pouyanebrahimi]

I have a question from this youtube video: 

My question is: 

What about if we have 5 parameters, Example:

[Query="EXEC sr_MERData '05/1/2019','12/31/2019','AAA','BBB','CCC'"]).

Do you know how I should deal with this? I just tried defining PARAMETER1 and added like: [Query="EXEC sr_MERData '05/1/2019','12/31/2019',&PARAMETER1,'BBB','CCC'", CreateNavigationProperties=false]). But it is not working.

[artemus · Accepted solution]

Try:

Query="EXEC sr_MERData '05/1/2019','12/31/2019'," & PARAMETER1 & ",'BBB','CCC'"

Also if PARAMETER1 is a string or date, you will need

Query="EXEC sr_MERData '05/1/2019','12/31/2019','" & PARAMETER1 & "','BBB','CCC'"