Forum Discussion
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...
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.