Forum Discussion
PowerQuery sharepoint Credentials
Strange. If without macro refresh shall work automatically if the user has organizational work account and this account has at least R/O access to SharePoint resource.
If Power Query can't recognize credentials pop-up window appears to select type of account and set credentials.
When I open PowerQuery, we would get the Credential Window where they can select anonymous, windows or others where they can use their 365 account to connect to their account.
May be it's because it goes throw VBA for refresh ?
Or because I fold some table on top of another ?
Usually privacy content will pop-up also.
A little strange then.
Perhaps VBA, but I'm not sure, never used it with Power Query. You may try with Automate, it's a simple script
function main(workbook: ExcelScript.Workbook) { workbook.refreshAllDataConnections(); }Creating the button for the script you share the link on script file.