•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel + Power Query and Power Automate
I am trying to have Microsoft Power Automate to refresh a report that exists in Salesforce. That report is linked to an excel file via a powerquery.
I have created a script on OfficeScripts that have workbook.refreshAllDataConnections(). It does update a pivot table, so I can tell that the script is runnint
The table that PQ puts the data in is set to not do Background Refresh and to refresh when opening the file.
What is the best way to have PA to refresh Excel’s PQ?
Table properties on
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel
#Power Query
#Power Automate
#Refresh
#Microsoft
#Salesforce
#Data Connection
#PQ
#Pivot Table
#OfficeScripts
#Excel File
#Workbook
#Background Refresh
#Data
#All Data Connections
#Table Properties
#Script
#Automation
#Office 365