question

JeannekedeLigt-3433 avatar image
0 Votes"
JeannekedeLigt-3433 asked VikiJi-MSFT commented

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

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 :
141422-input.png

This is how it looks
141389-power-query.pngin Power Query:

This the M code:
141367-m-code.png

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.


office-excel-itpro
input.png (80 B)
power-query.png (13.1 KiB)
m-code.png (9.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VikiJi-MSFT avatar image
0 Votes"
VikiJi-MSFT answered VikiJi-MSFT edited

Hi @JeannekedeLigt-3433,
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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JeannekedeLigt-3433,
Are there any updates or questions? Please feel free to post back.
Thanks.

0 Votes 0 ·
JeannekedeLigt-3433 avatar image
0 Votes"
JeannekedeLigt-3433 answered VikiJi-MSFT commented
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JeannekedeLigt-3433,
Thanks for your reply and sharing.
I'm very gald for you, could you please accept your reply as an answer? This action will help other users who are experiencing similar issues in this forum.
Thanks for your understanding.
Hope to have a nice day~

0 Votes 0 ·

Hi @JeannekedeLigt-3433,
If you have a chance to review this thread, please accept your reply as an answer.
Thanks.

0 Votes 0 ·