Execute SQL Server Stored Procedure With User Parameter In Power BI

Sometimes there is a situation in which we need to get data by consuming SQL Server stored procedure. SQL Server stored procedure has parameters which we need to pass dynamically. Power BI provides a functionality to execute Stored Procedure using Managed Parameters. During this article we will talk about, • How to create Manage Parameter • How to pass manage parameter to a Stored Procedure • Invoke Query Result and load data to Power BI Desktop

source http://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-power-bi/