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

Keyur Pandya 6 Reputation points
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.
36,595 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Alberto Morillo 33,001 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.

    0 comments No comments