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!

Dan44's avatar
Dan44
Helper I
2 years ago

foodd thanks and yes it would be something worth raising as an idea for - seems like quite a basic task that doesn't yet have integrated functionality 

foodd's avatar
foodd
Community Champion
2 years ago

Dan44 , JGroothedde 's suggestion is quite good.  Practical in nature and my go-to. Your thoughts address a larger issue that would improve the overall consumer experience.

 

Ideas

If you have a new idea for functionality or how something should work, you can certainly start a thread on the community to solicit feedback on your idea, but you should also post the idea in the ideas section of the website and solicit others to vote on your idea. The development teams use the Ideas area of the communities to build their development pipeline and a significant amount of weight is placed on Ideas that have lots of votes versus those that do not. The ideas areas of the communities are here:

Power BI - https://ideas.powerbi.com
PowerAutomate - https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
PowerApps - https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas