Forum Discussion
Solved
Create dynamic parameter(s) with values stored in sql server (stored proc)
Hi PBI Team, My dataset is linked using 'import' and a stored procedure in SQL server. I have created dynamic parameters (start date, end date, number) where I can enter values that change the re...
Dynamic parameters only work with DirectQuery, that is, not in Import mode.
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
Hi Alexis,
Thank you so much for your advise. I apologise for the delay in responding. When I tried to use DirectQuery (exec sp proc), I received the following error message: Incorrect syntax near the keyword 'exec' in Microsoft SQL. Syntax error near ')'. Then I took the following reference from the forum: Thanks.
https://community.powerbi.com/t5/Power-Query/Microsoft-SQL-Incorrect-syntax-near-the-keyword-exec-Incorrect/td-p/1084306