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
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
3 years ago

If you pick the stored procedure option in the dataset properties, then navigate to the parameters settings it should list all the parameters for your stored procedure. 

 

You can then click the fx button to add an expression and choose the UserID from the Built-in Fields

 

You will end up with a parameter setting that looks like the following and will pass the UserID value from the paginated report to your stored procedure