Forum Discussion
Helper IVExecute permissions denied on Stored Procedure connection
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.
Helper IVThank 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
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 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.