Forum Discussion
Power Query - Sharepoint: clearing permissions when file opens (or never save permissions)
Hello Anonymous
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 Anonymous
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