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

Great! Glad i could help!