Share via

Power query can not refresh at other users

Fadhilla Puji Cahyani 0 Reputation points
2024-12-16T07:01:44.12+00:00

I have power query from another sharepoint excel (master file). The data only refresh at my user (as admin) but other users don't. I suspect it is because other users don't have credentials to master file (and can't have because it is contain some private data). Is there any solutions to fix that without giving credentials to other users?

Thanks in advance.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,230 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 28,971 Reputation points Microsoft External Staff
    2024-12-16T08:23:13.9933333+00:00

    Hi，

    Data cannot be refreshed without permissions, because the data must be refreshed by connecting to the data source.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.