Forum Discussion
mjcastillo
8 years agoNew Member
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 filter all information in base the logged user.
How it works in power bi or is there some other way to the same results.
1 Reply
- v-jiascu-msftMicrosoft Employee
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