Forum Discussion
tahmid-bari
3 years agoFrequent Visitor
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...
- 3 years ago
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
AlexisOlson
3 years agoSuper User
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