I have several Excel files that have Power Pivots and Power Queries using an ODBC connection to Oracle. I’ve tried to use RefreshPivotTables, RefreshData, CalculateData methods with no luck. I tried using datamashup bu…...refresh query tables with data model or external database connection...