Method Calls to Refresh or Update Power Query Data in Office Scripts | Institute of Financial Studies — Automate your data pipeline from extraction to execution. Learn the precise TypeScript method calls and asynchronous properties required to programmatically refresh and update Power Query data connections using Excel Office Scripts.