Forum Discussion

Vinay96's avatar
Vinay96
Icon for Helper I rankHelper I
3 years ago

Pass User ID from Report Builder to Store Procedure

Hi; I know there is a Built in fields in Power BI Report Builder to get the logged in Username or User ID. What I need to do is pass the value of User ID to SQL to execute a stored procedure that wil...
Need Help
Vinay96's avatar
Vinay96
Icon for Helper I rankHelper I
3 years ago

Thanks, Can you pls provide the query in the Store Procedure to accept the User ID 

  • d_gosbell's avatar
    d_gosbell
    Icon for Super User rankSuper User
    3 years ago
    Vinay96 wrote:

    Thanks, Can you pls provide the query in the Store Procedure to accept the User ID 

    I don't have any query. You asked how to pass a value to a stored procedure and I've showed you the steps to do this. You can put whatever logic you like in the stored procedure based on whatever data you have in your database.