Forum Discussion

Dan44's avatar
Dan44
Helper I
2 years ago
Solved

Auto Refresh Excel File Connected to Semantic Model with Analyze in Excel

Hi all,   I have a semantic model which I have used Analyze in Excel to create an Excel Report. So the connection type is the following:   While the default is the file gets automatically s...
Need Help
  • JGroothedde's avatar
    JGroothedde
    2 years ago

    Hi Dan44 ,

    You can refresh the Excel files through Power Automate, see this helpful post for more information.

    I have just tested this myself an can confirm it still works. The script in question is:

     

    function main(workbook: ExcelScript.Workbook) {
	// Refresh all data connections
	workbook.refreshAllDataConnections();
}

     



     

    After creating the script, create a PA flow to run a script and you're good to go:

     

     



    Cheers!

JGroothedde's avatar
JGroothedde
Resolver II
2 years ago

Hi Dan44 ,

You can refresh the Excel files through Power Automate, see this helpful post for more information.

I have just tested this myself an can confirm it still works. The script in question is:

 

function main(workbook: ExcelScript.Workbook) {
	// Refresh all data connections
	workbook.refreshAllDataConnections();
}

 



 

After creating the script, create a PA flow to run a script and you're good to go:

 

 



Cheers!