Forum Discussion
Power Query Connection Refresh Sharepoint Online
I have an Odata connection to Sharepoint Online. The data from a list is displayed in the spreadhseet that is also saved to Sharepoint Online in the same site. I would like to open the Excel file o...
The ability to refresh a query from within Excel online can depend on how the administrator has set configurations. Yes, you can do this with Power Automate though. Here is an example.
I'm the tenant admin. How would I ensure Excel Online could refresh Odata?
Here is a good resource that describes requirements based on different scenarios.