Forum Discussion
Akshit_Bansal
Jun 24, 2024Copper Contributor
Automate running of Power Query when new file is uploaded to Sharepoint
I have a SharePoint/OneDrive folder where every week I upload an excel file containing data in a fixed format. I have made power queries to do some transformations on the excel data and output the tr...
JKPieterse
Jun 24, 2024Silver Contributor
Akshit_Bansal If the queries can be refreshed using Excel on-line, you could have your PowerAutomate Flow call a script like this one:
function main(workbook: ExcelScript.Workbook) {
// Refresh all data connections
workbook.refreshAllDataConnections();
}