Forum Discussion
Execute SQL Server stored procedure input parameters with power bi parameters
Hi All,
I have stored procedure in SQL Server which i need to bring the data in to Power BI. For that i have to pass two parameters which i wanted to pass with parameters defined in Power BI.
Can anyone tell me how to do this it is very much important for my project?
Hi chotu27
this is actualy pretty easy, once you have set up both parameters, in my case named CustomerID and ShipperID, just run the query with this M code:
=Sql.Database("server_name", "database_name", [Query="exec test_proc " & CustomerID & ", " & ShipperID])
2 Replies
Hi chotu27
this is actualy pretty easy, once you have set up both parameters, in my case named CustomerID and ShipperID, just run the query with this M code:
=Sql.Database("server_name", "database_name", [Query="exec test_proc " & CustomerID & ", " & ShipperID])
This assumes the query is already loaded (M-code interface).
How do you get the query (that calls the stored procedure) loaded in the first place (so that you can use M-code)?
