Forum Discussion

mjcastillo's avatar
mjcastillo
New Member
8 years ago

Dynamic Data Source passing active user like String through MySQL's Stored Procedure

In 'Datazen'  i used the sources calling a stored procedure, assings like string parameter the active user, somenthin like this:   call StoredProcedureName('{{ username }}')   and dashboard filte...
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi mjcastillo,

 

We can apply a custom sql statement while we can't make it dynamic. The could be other approaches. 

1. Use slicers.

2. RLS, please refer to power-bi/service-admin-rls.

 

Best Regards,

Dale