Forum Discussion
Excel Power Query - Data Source Settings - Sharepoint - Clearing permissions on file open
Hello @datasetleo
I think this is a doubled post.. however ... 🙂
as far as I know, the credentials are not stored in the file, but on the profile of the computer. So, as soon you pass the file to another computer or the file is opened by another profile, the credentials are no longer there and have to enter the credentials as soon as a refresh is executed.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello @datasetleo
I think this is a doubled post.. however ... 🙂
as far as I know, the credentials are not stored in the file, but on the profile of the computer. So, as soon you pass the file to another computer or the file is opened by another profile, the credentials are no longer there and have to enter the credentials as soon as a refresh is executed.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Makes pefect sense. But then when the file is opened by another user on another computer, why Excel automatically goes into anonymous mode and then fails query refresh instead of asking the user to choose how to sign in correctly? Any controls to change this?
this would be useful for me to know too.... I have mine connected to a D365 environment, and it doesnt automatically prompt the diferent user to enter their credentials when they try to reresh the data, just throws up access errors
