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...
  • 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.