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!

foodd's avatar
foodd
Community Champion
2 years ago

Hello Dan44 , and thank you for sharing your concern. Consider raising this as a new Idea. This form would allow community members to contribute feedback and their level of interest through a vote. Thank you!

 

Issue

If you have found a true bug or issue, you can make a post to the forum to let others know (and that would be very nice of you to do so). But if you want to get it fixed, you should post it in the Issues/Ideas (it varies) area of the community. Specifically, you should post it here:

Power BI - https://community.powerbi.com/t5/Issues/idb-p/Issues
PowerAutomate - https://powerusers.microsoft.com/t5/I-Found-A-Bug/bd-p/BugFound
PowerApps - https://ideas.powerapps.com


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

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

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