PowerQuery sharepoint Credentials

I wrote some files to simplify users. They select a file and some macro and power query will refresh and return them the information.   For a few of them, I need to refresh some data that is stored...