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

[mjcastillo]

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.

[v-jiascu-msft]

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