How to add a parameter in PowerBI to run against a SQL Stored Procedure

[csommerman]

How to add a parameter in PowerBI to run against a SQL Stored Procedure

[aduguid · Accepted solution]

Make sure you save your parameters as text not numbers.

Then if you use the format below in M you should be able to pass the values to your stored procedure.

let
    Source = Sql.Database("YOUR_SERVER", "YOUR_DATABASE", [Query="EXEC [dbo].[Your_Stored_Procedure] " & Text.From(ParameterStoredAsText1) & ", " & Text.From(ParameterStoredAsText2) & ";"])
in
    #"Added Index"