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
heidibb's avatar
heidibb
Icon for Helper IV rankHelper IV
9 years ago

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

 

Anonymous's avatar
Anonymous
Not applicable
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.

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

    Thanks Anonymous! 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.