Forum Discussion

chotu27's avatar
chotu27
Post Patron
7 years ago
Solved

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.   ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    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])

     

     

     

rkaratzas's avatar
rkaratzas
Helper I
3 years ago

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)?