Forum Discussion
Refresh OLE DB Query using Powershell
Hello,
I have an Excel model with powerquery connections which I need to refresh.
The .RefreshAll() command refreshes all the connections and the pivot tables in the workbook but I want to refresh only the connections and not the pivot tables
How do I accomplish this?
Here's an example of the one of the connections:
Application : Microsoft.Office.Interop.Excel.ApplicationClass
Creator : 1480803660
Parent : System.__ComObject
Name : Query - Fetch_AIO (REF) (4)
Description : Connection to the 'Fetch_AIO (REF) (4)' query in the workbook.
_Default : Query - Fetch_AIO (REF) (4)
Type : 1
OLEDBConnection : System.__ComObject
ODBCConnection :
Ranges : System.__ComObject
ModelConnection :
WorksheetDataConnection :
RefreshWithRefreshAll : True
TextConnection :
DataFeedConnection :
InModel : False
ModelTables