Execute permissions denied on Stored Procedure connection

[heidibb]

Hello,

My data connection is executing a stored procedure with parameters. 

When trying to refresh within the service, I am getting this error

I did find another thread that mentioned giving execute rights to the service account in SQL. I'm not sure exactly what that means though. is this something I can do within my desktop file? Is it something that needs to be done elsewhere? I just need to know if we need to get our Power BI administrator involved or if this is something I can do myself.

https://community.powerbi.com/t5/Integrations-with-Files-and/EXECUTE-Permission-denied/m-p/130850#M8...

Thanks in advance.

[heidibb]

Thank you! My question is what is "youraccount".

My powerBI file is refreshing in the service through a production enterprise gateway (not a personal gateway).

When looking at my gateway connection, I have "Use a data gateway" selected, then it lists the gateway information.... status, Department, Gateway, Contact information and Description. Is there something there that I need to specify when we are granting permissions

[Seth_C_Bauer · Accepted solution]

@heidibb "Your Account" is the account that was used to create the data source in Power BI. Go to Settings (wheel icon) -> manage gateways -> Click on a data source and the username and password are hidden (This is the account you need to grant permissions to.) Or, this should be an administrator account and be granted higher level permissions so you don't run into this all the time.

[heidibb]

Thanks @Seth_C_Bauer! I am not able to see the gateway details with my account. I will get in touch with our administrator to do this! I appreciate all the info!

Thanks you.

[Anonymous]

@heidibb,

Connect to your SQL Server instance with an admin account using SQL Server Management Studio, then open a query window, and execute the following command. “Youraccount” is the account that you used to connect to SQL Server in Power BI.

USE msr
GO
GRANT Execute ON [dbo].Get_TeamLeadDashboard_Sections TO ‘Youraccount’

Regards,
Lydia

[Seth_C_Bauer]

@heidibb  What gateway are you using, and is it the latest version? If you can execute the procedure in the Desktop, my initial guess is that the gateway is "not" personal and you have different credentials on the actual data source. In which case, I would confirm that the user account of that data source be validated in SQL to ensure it has the correct permissions to execute the stored procedure.