Azure SQL Database
An Azure relational database service.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have created a Stored Procedure, this procedure takes User ID as parameter. I am trying to pass logged in user in power bi as parameter but unable to find a way for the same.
Power BI user roles wont work here as I need to handle user filter at SQL and not at Power BI.
Any suggestions would help.
Thanks in advance.
Maybe row-level security is a good fit on this scenario. Here you will find an example how to create the filter function and the policy to filter data per user.