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.
I am after this feature too
Darren Foster commented
An update would be much appreciated on this.. any movements . There’s a lot of
Interest around this
Any updates on this?