Forum Discussion
Help Needed: Passing Dynamic Parameters to SQL Stored Procedure in Power BI
Hi manoj_0911 ,
Please refers to the following steps.
1.Open the Power Query editor and click Manage Parameters -> New to create a new parameter.2. Create parameters in the Manage Parameters dialog box.
3.Then connect to the SQL Server database.
In this SQL statement, the procedure name is followed by a series of values that correspond to the procedure parameters.
EXEC <YourProcedureName> 'Agent_Details','Group1,Group2','2024-08-01','2024-09-01'
4.After importing the data, go to the Power Query Editor again and open the Advanced Editor for the query you just imported, and copy the M code I provided earlier.Best Regards,
Dengliang LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have the same issue. I created a parameter with values tied to another table called SortBy which holds the valid list of parameters.
I have a slicer on the canvas tied to Sort Value
No action is taken when I select a value from that slicer.
I've been reading about binding a field to a parameter, but I do not have that option in my modeling - advanced settings.
Field parameters as a Preview Feature is checked in Options.
How can I expose the parameter the user so they can dynamically select a value that will refresh the visual with the correct passed parameter?
HI manoj_0911 ,
Could you pls confirm whether this approach works for azure sql mi as well?
