Forum Discussion
How to pass parameter value dynamically to sql server store procedure
Hello Everyone, Is there any possible way like, pass parameter value dynamically to my direct query (SP) and data has to be refershed to based on the given i/p parameter. With the current setup, ...
praveenk , Dynamic M parameters can help. But not sure if that is supported on SQL Server SP
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
amitchandak - Sorry for getting back to you late. I've been trying to run a direct query, but I keep getting an error. I checked out some posts in the community, but I still can't figure out the right syntax.
Syntax: EXEC [dbo].[SP NAME] @StartDate = '04/15/2023', @EndDate = '04/16/2023',
EXECUTE [dbo].[SP NAME] @StartDate = '04/15/2023', @EndDate = '04/16/2023'