Enable Office Scripts to refresh Power Query queries
Allow Office Scripts to refresh Power Query queries. It'd be very helpful to automatically refresh data using Power Automate, but that platform cannot currently refresh data.
Thank you for providing the feedback. Your input helps us in making the product better.
Reg. Power Query refresh action – yes, this is in our backlog. We don’t yet have an API that can refresh a Power Query. We’re working with the product team to prioritize the API. I don’t have an ETA yet. But, we’ll be monitoring this closely and update our docs once the feature becomes available. Feel free to email me if you need more details.