Power BI Dashboard connection with SQL server logged in user specific data

Keyur Pandya 1 Reputation point
2022-01-21T04:31:17.67+00:00

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.

Azure SQL Database
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
25,308 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 26,021 Reputation points MVP
    2022-01-21T21:31:01.23+00:00

    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.