Automated way to trigger data refresh for Excel file in Sharepoint online

Dear Nandan Hegde,

Yes, there are automated options available; however, the approach depends on the workbook's data source and refresh requirements.

For Excel files stored in SharePoint Online, there is no native SharePoint feature that automatically triggers Data > Refresh All on a scheduled basis. One common approach is to use Power Automate together with Office Scripts to run a refresh process against the workbook stored in SharePoint. Certain connection types and Power Query refresh scenarios may not be fully supported when the script runs in an unattended cloud flow.

If your requirement is to replicate the exact behavior of Excel Desktop's Refresh All feature, a more reliable option may be Power Automate Desktop, which can open the workbook in the desktop application, perform the refresh, save the file, and close it automatically.

To ensure that you get professional help and avoid incorrect information, I suggest you post on the Microsoft Power Automate Community for expert assistance. This is a specific channel related to Power Automate Microsoft Power Platform Community Forum Thread, you'll get the most qualified group of respondents, and other partners who read the forums regularly can share their knowledge or learn from your interaction. 

Apologies for redirecting you to a different community as the members of the posted category focus on users with Microsoft 365 concern and have limited knowledge about Power Automate, so to get a quick and better assistance, I redirect you in the correct way. 

I appreciate your patience and understanding and thank you for your time and cooperation. 

Hope you have a great day!