Forum Discussion

tahmid-bari's avatar
tahmid-bari
Frequent Visitor
3 years ago
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 result data in 'edit parameter'. However, I am having trouble (cannot find 'Advanced' option) binding those dynamic parameters to the newly created tables.

 

Furthermore, can I include another stored procedure in the dynamic parameter - number so that the end user can select from a drop-down list? In fact, because the (Dynamic M query parameters) feature does not support RLS, I am attempting to implement row-level security by creating a table in SQL Server and using DAX on the table (dynamic parameter - number).

 

I also understand that creating a dynamic user filter using a security field in the data can be done in Tableau, however, we would prefer to find a solution in the Power BI app. Thank you.

2 Replies