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...
I don't have a specific script. I'm using the data refresh capablilites of Excel. The more I read, it may just not be possible. I'm reading that the data refresh abilities is limited to only MSSQL.
I'm reading maybe opening up excel with Flows might work.
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.
