Forum Discussion

heidibb's avatar
heidibb
Icon for Helper IV rankHelper IV
9 years ago
Solved

Execute permissions denied on Stored Procedure connection

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 threa...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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