Excel Power Query only refresh the data with me, not with other users

Question

Hi,

I have an issue that I can't get resolved and I hope someone knows what's going on and can help me with a solution.

I created a native query in Excel (2016) using Power query.,

This query execute a stored procedure with parameters on a SQL server .

This value of a parameter is entered by the user in the relevant worksheet. So these values are the input for the query.

The command that is finally executed by Power Query then looks like this:

Exec <sp_getdatafromtable>'param1', 'param2', 'param3'

This is the input screen were the user can enter the parameter values :

This is how it looks
in Power Query:

This the M code:

Now the issue is that the data is only refreshed with me, but not with the final users.

All these users have access rights to the sql server in question. One even has admin rights (like me).

I have no idea what the cause is.

Who can help me with this?

thanks in advance,

Jeanneke.

Answer 1

Hi @Jeanneke de Ligt ,
Welcome to Q&A forum!

According to your description, I think the issue may be related to the file permission level.

• Did you create the file? And where did you save the Excel file?
• How did you share the file with others? Please raise the other users's permission level on the Excel file to the Full Control to see if it is feasible.

In addition, do other users have any prompts when refreshing? If so, please share with us.

Any updates, please let me know.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,

I found the cause. It was the M-code.
Find fere the solution: https://blog.crossjoin.co.uk/2016/12/11/passing-parameters-to-sql-queries-with-value-nativequery-in-power-query-and-power-bi/

Thanks.