Query with parameter

[Markzolotoy]

I am migrating a SSRS subreport to a paginated subreport. The subreport has a dataset that is based on a select from a stored proc. The select uses subrepport parameter. I see that I can create a parameter Power Query Editor/ Manage Parameters. But I can't see how I add this parameter to a particular query. Any idea?

Update. I was able to run SP, but when applying I am getitng the following:

Incorrect syntac near keyword EXECUTE. Incorrect syntax near ')'

Thanks

[v-yetao1-msft]

Hi @Markzolotoy 

Please take a look at the following links about use DAX query, parameters with report builder if they help:

https://www.mssqltips.com/sqlservertip/5865/sql-server-reporting-services-report-builder-with-dax-qu...

https://docs.microsoft.com/en-us/sql/reporting-services/tutorial-add-a-parameter-to-your-report-repo...

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Markzolotoy]

@v-yetao1-msft One link shows how to add a parameter to a report, the other shows how to use SSAS with Report Builder, again not a my case.

[amitchandak]

@Markzolotoy , Are you looking for something like this

https://www.fourmoo.com/2020/10/08/power-query-m-passing-parameters-dynamically-to-a-sql-server-quer...

[Markzolotoy]

Actual code looks like this:

Source = Sql.Database("localhost", "Vanduradb_New1", [Query="EXEC SP_Name " & #"ID" & ", " & "1"])

That seems to work. When I create a paginated report based ont that dataset how will I provide the ID parameter?