User Permissions to Refresh Power Query from Stored Procedure

[lesleycampbell]

I have an Excel 2010 file containing a Power Query that executes a Stored Procedure. The users trying to refresh the query are not able to. I have updated the properties of the Stored Procedure to allow them to execute it, but they still can not.

What else can I do?

 

[SkipVought]

hi,

Do your users have read access to the database?

 

[lesleycampbell]

I might make a mess out of this answer, so please bear with me.

The users have 'access' to the database with a log in to our software system. They do not have direct access (log in) to the server where the database is located.

Our server access is using Windows Credentials.

Does this help answer anything??

 

[SkipVought]

Well in order to run the procedure, they may need more access.

Check with your DBA.