SQL Server Store Procedure With Parameter In Power BI
SQL Server Store Procedure With User Parameter In Power BI Overview Sometimes, there is a situation when we need to get the data by consuming SQL Server Stored Procedure. SQL Server Stored Procedures have parameters that we need to pass dynamically. Power BI provides functionality to execute a Store Procedure using Manage Parameters. In this blog, we have look about the following. How to create Manage Parameter How to pass manage parameter to a Stored Procedure Invoke Query Result and load data to Power BI Desktop Limitation This feature will work only for Import Mode in Power BI Example I have a procedure in SQL Server its named “spGetEmpbyGenderandDepartment” it has two parameters named “Gender” and “Depart”. I want to use this procedure and load the data into Power BI Desktop. So, now let’s get started! Step 1 - Create Manage Parameter in Power BI Desktop Open Power BI Desktop and from Home tab, select “Edit Queries”.